Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro help | Excel Discussion (Misc queries) | |||
macro interruption: help!!! | Excel Discussion (Misc queries) |