open workbook to specific sheet

  • Thread starter Thread starter Mr E
  • Start date Start date
M

Mr E

I am trying to force excel to open to the same workesheet each time the work
book is opened. regardless of where it was last saved. Is this possible? If
so, how would you accomplish this.
 
In the 'ThisWorkbook' module, put the following code (adapted to the
worksheet you want)...

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub
 

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

How to force workbook to always open on the index sheet tab 2
Merge Multiple workbook sheets into one workbook 0
Force excel to open on a specific sheet 5
Excel Monthly Spread sheet. 12
Open Workbook to Specific Sheet 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Compile data from several workbooks 1
Can not copy a sheet to another book 7

Back
Top