Excel saving
I have a excel document with numerous sheets, each sheet has hyperlinks to
the other various sheets. Sheet 1 is a overview page with details listed on it. Is there anyway when opening the document to always view sheet 1 first. So you could save on any sheet, but it will always open on sheet 1? thks |
Excel saving
Put this macro in the workbook module. To access that module, right-click
on the Excel icon that is immediately to the left of the word "File" in the menu that runs across the top of the screen. HTH Otto Private Sub Workbook_Open() Sheets("Sheet1").Select End Sub "bushno8" wrote in message ... I have a excel document with numerous sheets, each sheet has hyperlinks to the other various sheets. Sheet 1 is a overview page with details listed on it. Is there anyway when opening the document to always view sheet 1 first. So you could save on any sheet, but it will always open on sheet 1? thks |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com