View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Enable Macros Warning

This is incorrect information. The workbook will not control the users
security level.

Regards,
Tom Ogilvy


"Henry" wrote in message
...
Phil,

Open the Workbook.
Goto ToolsMacroSecurity and set the security option to low.
Save the workbook.
Your users won't get that warning any longer.
Macros will always be enabled.

HTH
Henry

"Phil Perry" wrote in message
...
I believe you can't bypass the initial screen in Excel
which asks you to select to disable macros (default button
for pete sake) or enable macros. Is there a way I can
put a message on there to advise the program will not
run unless you enable macros...or other procedure to
overcome this.
cheers