View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
i-Zapp[_3_] i-Zapp[_3_] is offline
external usenet poster
 
Posts: 1
Default forcing 'macro enable' on open

Is there a way to essential "force" a user to enable macros by eithe
giving him the choice to enable, or if he doesnt then the workbook i
forced to close?

In other words, a user cannot edit the workbook without allowing macro
enabled.

I know that if the wb contains XL4.0 macros and the security level i
set to high, then this exact scenario exists... but i cannot ensure th
user's Excel security level is set to High

--
Message posted from http://www.ExcelForum.com