Opening a workbook on sheet 1

[Rpatel1974]

Good morning,

I had a question. I have a workbook that consists of 3 sheets, it's a template I use. Once I am done filling out sheet 3, I save as a new workbook. When I have to go back to the template workbook it always opens on sheet 3. Is there anyway that once I open the template workbook it will open on sheet 1?

Thanks for your help.

[ragulduy]

You need to put a macro, something like:

Please Login or Register  to view this content.

in the workbook object module. Presst Alt+F11 to open the vba editor, then in the project explorer, in the microsoft excel objects folder, right click on thisworkbook and select view code, then paste the above code in the window.