ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disabling Macros (https://www.excelbanter.com/excel-programming/381042-re-disabling-macros.html)

NickHK

Disabling Macros
 
That a user defined that you (the programmer) cannot change, thankfully.

You can sign the code and each user can install your certificate.
http://www.google.co.uk/search?hl=en...Search &meta=

Or if the code is no longer required, you can remove it:
http://www.cpearson.com/excel/vbe.htm

NickHK

"MacroLearning" wrote in message
...
I've have a report that runs on a macro. The macro is saved on it's own
spreadsheet. Once the macro is run, the report is saved in it's own file.
How do I keep the "enable/disable macro" prompt from showing up when other
people open the report?





All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com