Opening on a specific worksheet

T

Tim

Hi

I have a workbook with dozens of individually named sheets. Can I get Excel
2007 to open the workbook on the same sheet regardless of which sheet I was
working on when I closed/saved the workbook?
 
R

RonaldoOneNil

Tim said:
Hi

I have a workbook with dozens of individually named sheets. Can I get Excel
2007 to open the workbook on the same sheet regardless of which sheet I was
working on when I closed/saved the workbook?
Click to expand...
 
R

RonaldoOneNil

Don't know whats happening with my posts !

Open the VBA code page for ThisWorkbook and enter the following into the
Workbook Open function

Me.Sheets("YourSheetNameToOpen").Select
 

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

Excel shortcut options 0
Open Workbook on Specific Worksheet 3
Spelling checker problem on a specific worksheet only 1
Link one worksheet in a workbook to another worksheet in same work 1
Merge Multiple workbook sheets into one workbook 0
Sheet tab names change automatically 3
Opening a excel file to a specific worksheet. 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Top