open workbook on same worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Can anybody advise how I can get my workbook to automaticaly default to a
certain worksheet once opened,
ie when the workbooked is opened it will always default to the 'welcome'
worksheet.
thanks
ps I'm a novice - so go easy
 
Excel opens workbooks with the same sheet active as when the workbook was
saved. The only way around that is to use a macro to switch sheets when the
workbook opens. Of course this requires that the user not disable macros.

Open the VBE and select the ThisWorkbook module. Paste this code in,
changing Sheet1 to your sheet:

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


--
Jim
| Hi,
| Can anybody advise how I can get my workbook to automaticaly default to a
| certain worksheet once opened,
| ie when the workbooked is opened it will always default to the 'welcome'
| worksheet.
| thanks
| ps I'm a novice - so go easy
 

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

Multiple Workbooks using same macro 4
Code to format cells on several worksheets 2
Using cell as worksheet reference (macro) 1
Copy same formula to all worksheets in a workbook 1
Merge Multiple workbook sheets into one workbook 0
Link one worksheet in a workbook to another worksheet in same work 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
Printing Worksheet/Workbook 2

Back
Top