D David McRitchie Mar 19, 2004 #2 Hi Darren, watch your terminology.: workbook contains worksheets pages do not exist until you print. A workbook will open to the sheet that was active when you last saved (i.e. closed). ------------------------------------- If you want to always open to a specific worksheet, you can use Workbook_BeforeClose see . http://www.mvps.org/dmcritchie/excel/event.htm for a specific example you can go a Google Groups search Workbook_BeforeClose specific sheet group:*Excel* http://google.com/[email protected] Sub WorkBook_Open() 'form posting by Gord Dibben 01 Aug 2003 WorkSheets("Sheet1").Activate End Sub
Hi Darren, watch your terminology.: workbook contains worksheets pages do not exist until you print. A workbook will open to the sheet that was active when you last saved (i.e. closed). ------------------------------------- If you want to always open to a specific worksheet, you can use Workbook_BeforeClose see . http://www.mvps.org/dmcritchie/excel/event.htm for a specific example you can go a Google Groups search Workbook_BeforeClose specific sheet group:*Excel* http://google.com/[email protected] Sub WorkBook_Open() 'form posting by Gord Dibben 01 Aug 2003 WorkSheets("Sheet1").Activate End Sub
M Mike Mar 19, 2004 #3 darren said: how do i get te spreadsheet to open at a predretermined page Click to expand... Darren, You could add something like this to the ThisWorkbook code module (right click on the Excel icon next to File on the menu and choose View Code): Private Sub Workbook_Open() Worksheets("Sheet1").Select End Sub This will run every time the workbook is opened only if macros and events are enabled. Hope this helps, Mike
darren said: how do i get te spreadsheet to open at a predretermined page Click to expand... Darren, You could add something like this to the ThisWorkbook code module (right click on the Excel icon next to File on the menu and choose View Code): Private Sub Workbook_Open() Worksheets("Sheet1").Select End Sub This will run every time the workbook is opened only if macros and events are enabled. Hope this helps, Mike
D David McRitchie Mar 19, 2004 #4 Sorry change the occurrences of Workbook_BeforeClose to Workbook_Open. I wrote the comments before I did the search.
Sorry change the occurrences of Workbook_BeforeClose to Workbook_Open. I wrote the comments before I did the search.
