I have a spreadsheet with macros. Is there a way to set my Excel program to
make this spreadsheet a trusted source so the enable/disable popup doesn't
come up? Others in the office will be using this spreadsheet and it is a
pain to have to enable macros each time you open it.

On Jul 3, 11:13 pm, "ADK" wrote:
I have a spreadsheet with macros. Is there a way to set my Excel program to
make this spreadsheet a trusted source so the enable/disable popup doesn't
come up? Others in the office will be using this spreadsheet and it is a
pain to have to enable macros each time you open it.

The only way is for other people to set their macro security to low
(not recommended). This will let any macro run on their machine and
they wouldn't be any the wiser. (I certainly wouldn't do so.)

Otherwise you will have to digitally sign your macro and then others
can install your digital certificate which trusts your macro. You have
to purchase a certificate from some organisation such as Thawtes or
Verisign.

David

I just found selfcert which enables me to assign a cert and allows everyone
in the office to accept my cert, therefore removing the popup


wrote in message
oups.com...
On Jul 3, 11:13 pm, "ADK" wrote:
I have a spreadsheet with macros. Is there a way to set my Excel program
to
make this spreadsheet a trusted source so the enable/disable popup
doesn't
come up? Others in the office will be using this spreadsheet and it is a
pain to have to enable macros each time you open it.

The only way is for other people to set their macro security to low
(not recommended). This will let any macro run on their machine and
they wouldn't be any the wiser. (I certainly wouldn't do so.)

Otherwise you will have to digitally sign your macro and then others
can install your digital certificate which trusts your macro. You have
to purchase a certificate from some organisation such as Thawtes or
Verisign.

David