LinkBack URL
About LinkBacks
Hi Guys,
I have a work book with many sheets and staff continue to mess this up so I would like to know how I can have a specific sheet called Instructions open when this workbook is opened preferably no macro's is this possible
Hi Guys,
I have a work book with many sheets and staff continue to mess this up so I would like to know how I can have a specific sheet called Instructions open when this workbook is opened preferably no macro's is this possible
Last edited by FDibbins; 08-30-2013 at 12:34 AM.
Not without macros...the worksheet that will be active when the workbook is opened will be the sheet that was active when the workbook was saved unless a macro tells the workbook otherwise.
To do this with a macro, enter this code into the "ThisWorkbook" module:Hope this helps
Please Login or Register to view this content.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks Ajryan,
And thanks for not just answering the question without providing an alternative much appreciated.
No problems,
Can you please change the title of the thread to something appropriate to reflect your question, and also mark this thread as solved
Sorry I forgot to finish the title my bad
The title as it should be
lol thats ok, thanks for the change. You should have changed it in the 1st post though - I will do that for you, this time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks