Can you help me with the save as steps?


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.


Need Help with this Issue?

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


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