Displaying a certain spreadsheet everytime at startup.

[Tigerman68]

I have an Excel workbook made up of several worksheets that my employees work from. I would like for the workbook to open on the same spreadsheet each time it is opened no matter what spreadsheet the previous user was viewing when they last saved the workbook. Right now Excel just reverts back to the last spreadsheet that was viewed when the workbook was saved, which is its default behavior.

I've tried some VBA coding and checking through the options but I am unable to figure out how to do it. Anyone have a solution?

Thanks!

 

[GlennUK]

Put a Sheets(whatever).Activate in the Workbook.Open event.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Tigerman68]

That did it! Thank you, Glenn!