ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   enable macros accross the network (https://www.excelbanter.com/excel-programming/325842-enable-macros-accross-network.html)

rreneerob

enable macros accross the network
 
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?

ben

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?



All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com