View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default Don't open file if no response to enable macros

Hi
If someone opens an Excel file containing macros, I would like the file
to remain closed if they choose not to enable macros. A message like
"This worksheet must be opened with macros enabled. The file will now
close" would be nice.
Can any event capture the "enable macro" message box?

cheers
Paul