Hi,
Is there any VBA code that closes the Workbook if a user does not agree to
enable macros on startup?.

TIA,
Mickey

MDlake, if the user does not enable macros how is the code to close the
workbook going to run? Have a look here for a workaround

http://www.danielklann.com/excel/for...be_enabled.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"MBlake" wrote in message
...
Hi,
Is there any VBA code that closes the Workbook if a user does not agree to
enable macros on startup?.

TIA,
Mickey

Maybe you could lock and protect the entire workbook and have the startup
macro unlock it. That way if the user does not enable the macros the
workbook will be useless.

"MBlake" wrote:

Hi,
Is there any VBA code that closes the Workbook if a user does not agree to
enable macros on startup?.

TIA,
Mickey

Thanks for the replies, I looked at the code suggested and also a resource
here which I found very useful, others may as well -
http://www.vbaexpress.com/kb/getarti...b_id=379#instr

Thanks again,
Mickey