Open Workbook to Specific Sheet

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

How can I write a macro so that each time I open an Excel
Workbook it goes to a specific specified Sheet each
time. I have a macro but if the workbook file is saved
on another sheet it will open to the last sheet used.
 
Hi Dennis

Place the code in the "ThisWorkbook" module

Private Sub Workbook_Open()
Sheets("Sheet1").Select ' Amend as necessary
End Sub

--
XL2002
Regards

William
(e-mail address removed)

| How can I write a macro so that each time I open an Excel
| Workbook it goes to a specific specified Sheet each
| time. I have a macro but if the workbook file is saved
| on another sheet it will open to the last sheet used.
 
William, thanks for responding to my help message about
Excel. I tried your suggestion but can't get it to
work. I'm using Excel from Office 2000 and when I try
and save the macro you provided and use the word Private
the Macro disappears from the workbook.

My work book name is "Patrol111" and the sheet I want to
continually open to is called "Introduction". If I
create a macro as follows:

Sub Patrol111_Open()
Sheets("Introduction").Select
End Sub

The workbook accepts it but I have the same problem that
if I save the workbook while another sheet is open, the
next time I open the workbook it opens to the last sheet
it was on when I saved the file. I know it is probably a
simple fix but I can't do it for some reason. Just
getting old I guess. Anyway, thanks for your help and
any other information you can provide me would be greatly
appreicated.

Thanks again.

Dennis
 
Hi Pete, thank you so much, it worked really slick and it
was easy. I'm sure what William gave me should have
worked if I had done it right. Your method was easier for
someone that doesn't know too much about macros and the
Workbook modual. Thanks again.

Regards
Dennis
 
Back
Top