ExcelBanter - Opening on a specific worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Opening on a specific worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/263990-opening-specific-worksheet.html)

Tim

Opening on a specific worksheet

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?
--
TIA

Tim

RonaldoOneNil

Opening on a specific worksheet

RonaldoOneNil

Opening on a specific worksheet

"Tim" wrote:

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?
--
TIA

Tim

RonaldoOneNil

Opening on a specific worksheet

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

"Tim" wrote:

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?
--
TIA

Tim

All times are GMT +1. The time now is 01:08 PM.