Requiring Save As without making file read only

[redstang423]

Hi Everyone,

I have a file which is used as a template and can't be saved with data entered into it. My first thought is to password the file to only open as a read only, but that turned up two issues. First, this will likely confuse some of the users, as they are not well versed in computers beyond the basics. Secondly, I am adding a command button that will allow someone who doesn't know Excel very well (and subsequently, likely won't know any vba) to add things to the raw data in the template and save it as the current file name. That should be the only situation in which they can save this file as its current name. Perhaps I am just thinking about this too hard and its much easier than I am making it out to be, but if anyone can give me guidance, it would be appreciated.

Thanks!

Jeff

[mikerickson]

It sounds like this Workbook_beforeSave routine would help you. The user can save the workbook with any name except the originalTemplateName.

Please Login or Register  to view this content.

[redstang423]

Thank you very much! I haven't tried it yet, but I can tell that at the very least, it'll give me the base code that I wouldn't have been able to come up with myself. I appreciate you help!

Jeff

[redstang423]

OK, so I've implemented the code and modified it to add in a password option to allow using the save button. I have a slight problem, however. The code still runs when using File>SaveAs. Did I end up altering it in some way that makes it come up all the time?

Please Login or Register  to view this content.

Thanks!

[mikerickson]

The problem is that the Before_Save event occurs before the user enters the SaveAs box appears.

Your routine will prevent the template being Saved (without password) .

If you put

Please Login or Register  to view this content.

at the start of the routine, the routine won't run if the user has called SaveAs.

On the other hand, the User will be able to click SaveAs and not change the name and still successfully save the template file.


I'm reminded of an old saying, "it difficult to make anything foolproof, because fools are so ingenious."

(P.S. I suspect you may have other questions. If so, I'm leaving town for the weekend, not ignoring you.)

[redstang423]

That works fine for my purposes. Its really just in there to try to prevent someone from accidentally saving over the template without knowing that you are about to do so. If there is a way to prevent saving with the same file name after using "SaveAs", I'll take it, but it isn't nessecary. I also just realized I changed how I was trying to set it up from what I originally posted, and I no longer have the button to start the save, and forgot to mention that part.

Thanks for your help!

Jeff