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?