Enable / Disable Macros (Excel 2000)

Topic

New Reply

When a user opens or starts the excel file “2001 Reporting.xls” and the macro warning msg is presented giving the user the option of enable or disable; Can code be inserted that would simply close the file if the user selected DISABLE? The program is useless without it’s macros and it opens it up to mischief. So if they choose not to enable macros, then I don’t want them to have access to the file!

Reply | Quote

Replies

Ricky,

Once macros are disabled code cannot run. The option to disable macros is for security purposes and it would be pointless having the disable feature if code could still run. Probably your best solution is hide all sheets bar one, and when the file is opened run code to unhide them. If macros are disabled the code will not run and your sheets will remain hidden. Of course when the file is being closed the reverse would have to take place. If you have a lot of worksheets, this might effect performance.

Andrew C

Reply | Quote