Enable Macro

[Guest]

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

 

[Andy Brown]

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

 

[Bernard V Liengme]

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