Thread: Disabled Macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default Disabled Macros

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