View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default enable macros accross the network

rreneerob,

If you wish to keep your macro security on Office on high may I
reccomend using MakeCert.exe to sign your work, and install the certificates
on the machines in question? goto google and search for MakeCert you will get
a lot of hits on how to do this.
ben

"rreneerob" wrote:

I have a shared spreadsheet that is saved on one of the network servers. I
created two simple macros from my work PC, with the designated spreadsheet
open. When others try to use the macros from their PC's, they receive error,
"The macros in this project are disabled. Please refer to online help or
documentation of the host application to determine how to enable macros."
Any sugestions? Is there a way to save the macros to a organization-wide
template files?