Thread: Enable Macro
View Single Post
  #3   Report Post  
Bernard V Liengme
 
Posts: n/a
Default

Tools|Options; open Security tab; click on Macro Security button (lower
right) and set to taste.
Beware that this will let macros run that you did not write, also

best wishes
Bernard

"PW11111" wrote in message
...
Hi,

I am developing a spreadsheet - its has a number of Macro's. Every time I
open the sheet its asks me if I want to Enable / Disable Macro's. I know
that
a digital signature / certificate would stop this message appearing.

Does anyone know of a work around to stop this message from appearing -
using a networked computer I cannot attain a digital signature.

Any help would be much appreciated.

Phil