Workbook open to the same sheet

G

Guest

I'd like to know how to open the the same sheet of the workbook, regardless
of at which sheet it was save last.
Thx.
cg
 
J

JE McGimpsey

One way:

Put this in the ThisWorkbook module of the workbook:

Private Sub Workbook_Open()
Sheet1.Activate
End Sub

Where Sheet1 is the code name of the sheet you want to open.
 
G

Guest

Did try on a module but not work!

How do I get to the ThisWorkbook module from
Tools
Macro
Visual Basic Editor
Thx.
cg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Sheet Values to new workbook 20
Always open a workbook on Sheet1 regardless of sheet viewed when lastsaved 2
Copy cell value from one worksheet to matching worksheet in another workbook 4
Excel shortcut options 0
enter key behavior - by sheet 4
save worksheet data to alternate closed workbook - next row 1
Opening a workbook to a certain sheet 2
Save with ref. to cell A1 2

Top