Open Excel to a specific worksheet 3

[Bill4tektips]

I have an excel workbook that contains several worksheets and I would like it to always open with a specific worksheet that contains instructions on how to complete the spreadsheets. Does anyone know if this is possible?

 

[combo]

Not without macro. Workbook opens with sheet active on saving.

combo

 

[Gavona]

Maybe you could put a hyperlink to your instruction sheet in cell A1 of all sheets. Not the solution asked for but could encourage the user to go there - especially if you format to draw attention to the link.

Gavin

 

[kjv1611]

If you're comfortable at all, or willing to try, I'd suggest setting it up via a macro. Follow combo's link if you want to get help on getting that setup. It's VBA programming in Excel.

--

"If to err is human, then I must be some kind of human!" -Me

 

[Kurupt55]

Although this is not the macro/vba forum if you want to have the sheet selected on open put this code into a module in vbe

Sub Autpen()
sheets("Sheet1").select
End Sub

Impossible is Nothing