Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jan
 
Posts: n/a
Default Disable macro security for selected workbook

I am using Excel 2003. I know how to lower the macro security warning from
Tools, Option, etc. However, I do not want to turn this feature off for
every workbook.

I only want to turn it off for a specific workbook when ever the end user
opens it. Can this be done? Maybe with VBA? How?

TIA.
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Jan

If you think about it, being able to lower macro security from a macro may
defeat the object.

You could sign the project and that could then be added to the trusted list
or you could install it as an add-in (*.xla). Neither way will fire the
warning

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Jan" wrote in message
...
I am using Excel 2003. I know how to lower the macro security warning from
Tools, Option, etc. However, I do not want to turn this feature off for
every workbook.

I only want to turn it off for a specific workbook when ever the end user
opens it. Can this be done? Maybe with VBA? How?

TIA.



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
Issuing macro in workbook from separate workbook Nigel Excel Discussion (Misc queries) 1 May 16th 05 05:46 PM
Formulae, conditional formatting & macro security Kevin Lucas Excel Discussion (Misc queries) 7 March 15th 05 01:10 PM
Extract specific data into its own workbook via macro? Adrian B Excel Discussion (Misc queries) 2 February 24th 05 06:09 AM
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM
workbook macro help ditchy Excel Discussion (Misc queries) 2 December 27th 04 04:48 AM


All times are GMT +1. The time now is 05:47 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"