Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating application error responses
I there a way to have the workbook automaticlly respond to the 'Enable Macro'
error message at startup, I get tired of clicking it and when I digitlly sign the workbook it tells me that I am not a trusted macro publisher. I thought I might be able to circumvent the application and make it answer its own question. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating application error responses
No, that is intended to block viruses for inadvertedly opening a file that
will run a malicious code. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Mekinnik" wrote: I there a way to have the workbook automaticlly respond to the 'Enable Macro' error message at startup, I get tired of clicking it and when I digitlly sign the workbook it tells me that I am not a trusted macro publisher. I thought I might be able to circumvent the application and make it answer its own question. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating application error responses
Not recommended, but it is possible.
You can go to Tools--Options--Security and click the Macro Security button. Then set it to Low. That will cause the Enable Macros message to not display at all. Mekinnik wrote: I there a way to have the workbook automaticlly respond to the 'Enable Macro' error message at startup, I get tired of clicking it and when I digitlly sign the workbook it tells me that I am not a trusted macro publisher. I thought I might be able to circumvent the application and make it answer its own question. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
Automating An Excel 2007 Application using VB | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Error 1004, Application-definded or object-defined error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |