Hello,
I'm trying to run a macro using the event, Workbook_Open(). The problem I'm having is when I open the file I'm asked if I want to enable macros. After I click enable, the macro does not run. I would like to keep the same security level and not always allow macros for when I'm using Excel in a different manner.
Thanks
Workbook_Open code must be in the ThisWorkbook module.
Entia non sunt multiplicanda sine necessitate
The macro I'm wanting to run must be in the ThisWorkbook module too then and can't be in an individual sheet?
No, just the Workbook_Open code.
I get a "Sub or Function not defined" error. OpenFile#_Click is in 4 different sheets.
Please Login or Register to view this content.
I wouldn't do it that way.
The click event in each sheet module should call a procedure in a code module, which you could also call from the ThisWorkbook module.
I'm sorry, I'm not following. I have a button on Sheet 1 named OpenFile1. I have code in a sub called OpenFile1_Click() which is located in Sheet 1 under Microsoft Excel Objects. Is this not correct?
Yes, that correct.
Then there's code in each of those click events. That code, if it needs to be invoked from more than one place, should be placed in a CODE module, and called from both the Click event and the Workbook_Open event.
Think of it this way: The Workbook_Open event isn't clicking the buttons, it's causing the same code to run as runs when you click the button.
Last edited by shg; 05-25-2010 at 05:24 PM.
I'm wondering now if this will work because when I open my Excel sheet the event will never run the macro because I don't have macros enabled. Once I enable macros after opening the sheet the event would have already run. Is that correct?
Thanks for all your help.
If you disable macros, no macros run; if you enable them they do. What third alternative are you wondering about?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks