Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 159
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 791
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 638
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
runtime error '1004' application or object defined error. Please help deej Excel Programming 0 August 1st 07 09:26 AM
Automating An Excel 2007 Application using VB Brad Wylie Excel Programming 2 January 27th 07 10:21 PM
Run Time Error 1004: Application or Object Defined Error BEEJAY Excel Programming 4 October 18th 06 04:19 PM
Error 1004, Application-definded or object-defined error Mirco Wilhelm[_2_] Excel Programming 9 January 7th 06 04:56 PM
run-time error '1004': Application-defined or object-deifined error [email protected] Excel Programming 5 August 10th 05 09:39 PM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"