This is not a direct answer to your question but:

You could also move your macros to a single spreadsheet
and turn it into an Add-in (.XLA) file. Spreadsheets
that use the macros from the XLA files don't flag as security
problems. They are also easier to maintain since the code
is in one place rather than many. You must add the add-in
though via Tools-Add-Ins.



"Worsty " wrote in message ...
Could someone please give me the code to automatically enable Macros in
Excel so that the user doesn't get the prompt when opening the
workbook?

Thanks,


---
Message posted from http://www.ExcelForum.com/