Enable Macro
 

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

Record a macro to open the workbook, store the macro in Personal Macro
workbook. Then assign the macro to eg: a custom toolbar button. If you open
the workbook by clicking the button ("programmatically") the prompt should
be suppressed.

HTH,
Andy

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