Tweet
To preface this question: I work with Macros, VBA, Excel 2007 all the time. I already know how to open an excel file, enable macros, record macros, write macros from scratch, the works.
The Question:
What I can't figure out is how to enable macros within a file once I have already disabled them (once the "Security Warning" message bar disappears). Does anyone know how to do this without closing the file and reopening it? I have a feeling there is a button someplace that will enable macros, I just can't find it. I also tried google, but all of the results say "Click the Options button on the message bar"... Duh, thats how I disabled them! and now the message bar is gone!
The Backstory:
In some of my files I use the Auto_Open() macro name to automatically run the second the file is opened (and macros are enabled). However 10% of the time I actually need the macro to not run right away. So when the message bar appears that says "Security Warning Some active content has been disabled." I choose not to enable the content and close the dialog box.
After I do my necessary work, I want to run my macros. Of course I now have no idea how to enable them without saving, closing, and reopening the file and depending on the size of the file and the slowness of our network, this could take a while.
So back to the question: Does anyone know how to do this without closing the file and reopening it? And to clarify, I do not want to change my default security setting. I already know how to do this. I just want to be able to disable and enable macros in this file only, just this once.
The Question:
What I can't figure out is how to enable macros within a file once I have already disabled them (once the "Security Warning" message bar disappears). Does anyone know how to do this without closing the file and reopening it? I have a feeling there is a button someplace that will enable macros, I just can't find it. I also tried google, but all of the results say "Click the Options button on the message bar"... Duh, thats how I disabled them! and now the message bar is gone!
The Backstory:
In some of my files I use the Auto_Open() macro name to automatically run the second the file is opened (and macros are enabled). However 10% of the time I actually need the macro to not run right away. So when the message bar appears that says "Security Warning Some active content has been disabled." I choose not to enable the content and close the dialog box.
After I do my necessary work, I want to run my macros. Of course I now have no idea how to enable them without saving, closing, and reopening the file and depending on the size of the file and the slowness of our network, this could take a while.
So back to the question: Does anyone know how to do this without closing the file and reopening it? And to clarify, I do not want to change my default security setting. I already know how to do this. I just want to be able to disable and enable macros in this file only, just this once.
Comment