Open Specific sheets in a workbook

[gmcgrane]

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

[ajryan88]

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:

Private Sub Workbook_Open()
    Me.Worksheets("Instructions").Select
End Sub

Hope this helps

[FDibbins]

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)

[gmcgrane]

Sorry I forgot to finish the title my bad

[gmcgrane]

Thanks Ajryan,
And thanks for not just answering the question without providing an alternative much appreciated.

[ajryan88]

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

[gmcgrane]

The title as it should be

[FDibbins]

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