Create an add-in that has all of your macros in it. This is just a workbook
with the workbook add-in property set to true. The user then only has two
choices: no open or enable macros. Also, it makes it easy to issue new
macros without having to issue a new workbook.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"LiSa" wrote in message
...
Is there any way of not allowing a workbook to be opened
if the macros are disabled?