T Trip Levert Dec 8, 2003 #1 Is there a way to set an excel file to open to the same worksheet regardless to where it was last saved?
Is there a way to set an excel file to open to the same worksheet regardless to where it was last saved?
C Chip Pearson Dec 8, 2003 #2 Trip, In the ThisWorkbook code module, put the following code. Change "Sheet1" to the desired worksheet name. Private Sub Workbook_Open() Worksheets("Sheet1").Select End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Trip, In the ThisWorkbook code module, put the following code. Change "Sheet1" to the desired worksheet name. Private Sub Workbook_Open() Worksheets("Sheet1").Select End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
