View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Turning off macro disabled pop-up

Hi

You can attatch a digital signature to the file, if so it says something
like "This workbook contains macros by Great Stan the Man". And if the user
adds this signature to the trusted source list then they won't be asked
again. Or you could put your code in an addin and have your users install it
with the Tools Addin menu.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"pcw" skrev i melding
...

I am trying to turn off the macro disabled popup without
having to resort to setting the Security level in the
Options tab ? Is there a way to do this.