HI,
I have a s/sheet that everytime someone opens it, it will open to deafult in worksheet xxx
Any ideas?
Thanks
Antony
HI,
I have a s/sheet that everytime someone opens it, it will open to deafult in worksheet xxx
Any ideas?
Thanks
Antony
It requires VBA code in the Workbook_Open event.
Three options in the code below. Pick one and delete the other lines.
Adjust the sheet reference per your needs.
![]()
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
This code will open the spreadsheet Sheet1 (tab name) when the workbook is opened.![]()
Please Login or Register to view this content.
Write this code in Workbook_Open event.
Hope that helps.
Last edited by vijay2482; 10-23-2009 at 07:35 AM.
VIjay
If you find any of the post useful to your question, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post.
vijay2482, that will use the sheets tab name.will open the spreadsheet Sheet1 (code name and not the sheet name)
for code name use,
![]()
Please Login or Register to view this content.
Oops, sorry for that.
I made a mistake while putting it into words.
Its the tab name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks