Macro - When opening file return to tab main_Menu

[Johnny Thunder]

Hello,

I am trying to enter a macro for when my excel fie is opened it will go to a specific tab ("Main_Menu") always.

This is so that when my shared filed gets saved in another tab the next user that opens it will go directly to the Main_menu tab.

Thanks in advance for your help!

 

[SamTYler]

Try changing the word "Worksheets" in the macro to "Sheets."

There are several Types of sheets in a workbook. "Sheets" includes all sheets, where "Worksheets" only contains sheets of Type:= Worksheets.

 

[Johnny Thunder]

Justin,


Your solution worked perfectly, by changing the Tab name to just "Main" it works!

 

[erik.van.geit]

Justin,


Your solution worked perfectly, by changing the Tab name to just "Main" it works!

then you didn't have a sheet called "Main_Menu"

 

[Johnny Thunder]

I did, but for some reason it would not link to the tab name?

I renamed it "Main" and it worked perfectly so i tried again... i renamed it back to "Main_Menu" and it would not link? But it works now with "main" so I am happy.

 

[erik.van.geit]

Very strange; if you want to email me the "not working" workbook (please clear all data) with the Tab "Main_Menu", I would like to investigate what the problem could be.

have a nice weekend!
Erik