ExcelBanter - Open workbook with same worksheet

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Open workbook with same worksheet (https://www.excelbanter.com/excel-programming/356732-open-workbook-same-worksheet.html)

pkeegs

Open workbook with same worksheet

How can I always open a workbook at the same worksheet?

Chip Pearson

Open workbook with same worksheet

Create a macro like

Sub Auto_Open()
ThisWorkbook.Worksheets("Sheet2").Select
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"pkeegs" wrote in message
...
How can I always open a workbook at the same worksheet?

All times are GMT +1. The time now is 04:37 AM.