Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issuing macro in workbook from separate workbook | Excel Discussion (Misc queries) | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
workbook macro help | Excel Discussion (Misc queries) |