I used to know how to do this and now I've forgotten again. I've pasted this code into the "ThisWorkbook" section. What else do I need to do to ensure that the code will automatically run when I open the file??
Please Login or Register to view this content.
Do you mean this?
Please Login or Register to view this content.
Last edited by stnkynts; 04-05-2013 at 10:36 AM.
the Auto_open routine needs to be in a standard module.
But as stnkynts says, you can use the Workbook_Open event of the Thisworkbook object
Thanks Guys! I got my macro to run!!. Do you know how to make a change event Sub? I used to have the code, but have since lost it. Sub Change_Event() ?????
The events for a worksheet/thisworkbook object can be generated by selecting the correct Object and Procedure from the drop down list in VBE.
right click sheet tab and view code to get to vbe.
What drop down list are you referring to? The one that comes up when writing code? Can you give an example of a change event sub?
vbe.jpg
The 2 drop downs at the top of the code window
Please Login or Register to view this content.
That's awesome! I've never played with those dropdowns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks