In running a google search, I came across the following code to have a worksheet open automatically when a workbook opens...
Yet it does not seem to function properly. (I am trying to open sheet "Info") attached a sample here..... Any thoughts on how to fix this???
Please Login or Register to view this content.
What do you mean when you say, "it does not seem to function properly"? It seems to function just fine for me on my machine.
My only recommendation at this point is to add a stop statement at the top of the procedure
Then, when you open the workbook, it should bring up the VBA editor in debug mode at the Stop statement and allow you to test and debug the code to see why it is not working.Please Login or Register to view this content.
If it fails to bring up the VBA editor in debug mode paused at the Stop statement, then you know that it is failing to execute the workbook_open() procedure, and can work on figuring out why it won't call the procedure.
Originally Posted by shg
Yep. works for me too.
Suspect that means that you have not enabled macros, or Event Handling is set to False (if it is, use Application.EnableEvents = True)
Have you checked that the Open Event is being executed?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
When i open the file, it does not open that Worksheet. I am relatively new to Macros... so not entirely sure what you mean by "Open Event" being executed. I do have macros enabled.... and attached a copy of the macro workbook up above.
If i open the file that is attached, it does NOT open the tab "info" however no errors pop up either.
If i hit Alt F11 and open the code...... if i hit the "play" arrow, the code runs as it should when the file opens... but it just does not run automatically when the file opens.
Meaning that the "open event" procedure should automatically execute when the workbook opens. The reason I suggested adding the Stop statement was to provide a way for you to see when Excel/VBA chooses to execute the code. If you add the stop statement, save the file, then reopen, you should end up with the procedure paused at that statement. If it does not automatically come up, then it is not executing the procedure as it should.so not entirely sure what you mean by "Open Event" being executed.
As both TMS and I have noted, it seems to work just fine for us, so there must be something different about your Excel environment. Did you check the Application.enableevents property to see if it had been set to false? https://msdn.microsoft.com/en-us/lib.../ff821508.aspx
Press Alt-F11 to open the VBE.
If the Immediate Window is not displayed, press Ctrl-G
Type: ?Application.EnableEvents and press Enter
If it returns False, type: Application.EnableEvents = True and press Enter
Close the workbook and open it again
event handling was set to false... it did work when i changed it to True, then it did work. So how do i make sure that this is set to true for other files/computers that this would be used on??? Or is that a setting that goes with the excel sheet when it is downloaded to other computers?
Pretty sure it's set for the session and will affect all workbooks. Closing and restarting Excel should reset it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks