View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default force a macro to execute

Valeria,

No, there is no way to force enabling of macros. But...

Hide all the sheet in the workbook except for a single sheet with a warning
in large text that the workbook won't work unless macros are enabled, and
unhide the remaining sheets and hide the warning in an auto_open macro.

Robin Hammond
www.enhanceddatasystems.com

"Valeria" wrote in message
...
Dear experts,
is there a way I can force users to enable macros when they open a certain
workbook, or at least provoke a warning message if they disable them?
Thanks!
Best regards,
--
Valeria