Recycle your Computers & Technology with us.

Can you help me with the save as steps?

Posted By : ricardo of Katharine Gibbs School - New York on April 7, 2003

Follow us on Facebook   Follow us on Twitter   Follow us on LinkedIn

Let Data Doctors be your personal IT department today

I have an Excel document that I want to protect in the following way:

1.) When the document is modified and the "Save" button is selected, a password is required to complete the "Save" process.

2.) When the document is modified and the "Save As" button is selected, the "Save As" window will force to save the document with a new file name (not the current name of the file), to a directory of the individual's liking.

Unfortunately I don't know enough about VB to pull this off. I've found a few snippets of code here and there, but nothing that will entirely do the trick. Please help.

This question was answered on April 7, 2003. Much of the information contained herein may have changed since posting.


Rmarchi

About the author

Posted by ricardo of Katharine Gibbs School - New York on April 7, 2003

Need Help with this Issue?

We help people with technology! It's what we do.
Contact or Schedule an Appointment with a location for help!