View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Jim is offline
external usenet poster
 
Posts: 615
Default passwords incompatible with macros in 2007?

OK,
In order to get this to work I had to:
Right clicking in "Security" and choosing new DWORD value
ExcelBypassEncryptedMacroScan
(decimal value 1)

It it's in trusted directory it will just run the macros. If it's in a
non-trusted directory, it gives me the option.

Thanks!