How do I disable the save icon in a workbook? I've tried this:
and assigned it to a button but to no avail. Any suggestions?![]()
Please Login or Register to view this content.
How do I disable the save icon in a workbook? I've tried this:
and assigned it to a button but to no avail. Any suggestions?![]()
Please Login or Register to view this content.
BETTER SOLUTION:
define a boolean variable, set to false on workbook open
on BeforeSave event, check if boolean is false, if so cancel save, exit procedure and tell user they must use a custom button to save the file
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
From my testing so far, going this route will disable the Save icon on ribbon, the Save menu item, the Save As menu item, and the Save keyboard shortcut.![]()
Please Login or Register to view this content.
...ok, so it doesn't actually disable these items, it prevents the user from being able to use them to save the file...basically forces them to use a control button you've placed on the sheet.
Still curious as to why the code in my OP doesn't work though
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks