Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent disabling of macros?
Dear All
Does anyone know how to prevent a workbook from opening if the user chooses to disable macros? (eg they have the Security Level set to 'high'). I want to use code to provide certain protections to spreadsheets (for example, to ensure that users can't copy and paste data). But if the user opens without enabling macros, they can bypass these extra protections. I have thought of one way: Upon saving, hide all sheets except for one sheet with a message on it "In order to use this spreadsheet, you must enable macros". Upon opening, code unhides the other spreadsheets and hides the first sheet. When combined with Protect Workbook Structure this works, kind of. But it's pretty clumsy and looks a bit confusing to the user (they get a brief period of time to read the first sheet when the book loads). Cheers Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling macros | Excel Discussion (Misc queries) | |||
Disabling Macros | Excel Programming | |||
Disabling Macros | Excel Programming | |||
Prevent user disabling events | Excel Programming | |||
Prevent user from disabling macros | Excel Programming |