Is there any way of not allowing a workbook to be opened
if the macros are disabled?

No, that is a user's choice. You can hide worksheets and have your code
unhide them - so if it is opened with macros disabled there won't be much
usability. This will encourage users to enable macros.

--
Regards,
Tom Ogilvy

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

No there isn't. About the best you can do is have your workbook in such a
state that it cannot be used with macros disabled, such as having key sheets
hidden.

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

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?