I'm looking for help in being able to selectively disable the 'Save As' capability in Excel. I have a template in which end users should not be able to use the Save As command, but admins (using a password-protected UserForm would have ability to Save As for maintenance purposes). I have used the following code:
This works perfectly to disable the Save As process, but I would like to enable it for admins via an option on an admin UserForm (I use radio buttons on the UserForm with an execute button). Hopefully this makes sense.Please Login or Register to view this content.
Bookmarks