Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default enable macros as default

In my Excel applications I never need to disable macros.
It would be nice if I could somehow bypass the enable/disable dialog box
when opening workbooks or at least have enable as the default option.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 135
Default enable macros as default

Josh, you could set the security to low, not recommend, or if you are using
excel 2000 or newer you could add a digital signature to the workbook, have
a look in help for information on this

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"josh" wrote in message
...
In my Excel applications I never need to disable macros.
It would be nice if I could somehow bypass the enable/disable dialog box
when opening workbooks or at least have enable as the default option.




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default enable macros as default

Thanks Paul B. Just what I wanted to hear. Now I just have to jump through
all the digital signature hoops and I'm home free. In the mean time I set
Excel's security level to low.

"Paul B" wrote in message
...
Josh, you could set the security to low, not recommend, or if you are

using
excel 2000 or newer you could add a digital signature to the workbook,

have
a look in help for information on this

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"josh" wrote in message
...
In my Excel applications I never need to disable macros.
It would be nice if I could somehow bypass the enable/disable dialog box
when opening workbooks or at least have enable as the default option.






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
ENABLE MACROS CarolAn Excel Discussion (Misc queries) 2 August 4th 09 07:21 PM
Enable Macros excelnewbie Excel Worksheet Functions 2 September 18th 05 04:17 AM
Enable macros..... Excel[_3_] Excel Programming 1 September 30th 03 03:48 PM
Suppress the Disable Macros / Enable Macros Dialog Shoji Karai Excel Programming 5 September 24th 03 03:10 AM
re-enable macros Ian[_7_] Excel Programming 1 July 11th 03 03:25 PM


All times are GMT +1. The time now is 07:31 PM.

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"