Is there a macro that can disable both the SAVE and SAVE AS features in Excel? I've created a report that users can access but due to the sensitivity of the data shoud not be able to save the report or save a copy of the report.
Is there a macro that can disable both the SAVE and SAVE AS features in Excel? I've created a report that users can access but due to the sensitivity of the data shoud not be able to save the report or save a copy of the report.
Well.....like this:
I'm am curious though how you are going to save the document, which has a new macro, when you prevent saving of any kind through said macro. A better way would be to allow only a certain user, you, to save it.![]()
Please Login or Register to view this content.
or...
![]()
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
If you do not want a wok book saved then just make it read only
Thanks @stnkynts and @john55. I'll try those out and see if they work. @coreytroy yes I can open the file as a read only, but I cannot control how others open it. And that's what I'm trying to do.
Anyone can copy a file in Explorer without ever opening it.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks