Using code in Excel
Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub
'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Cheyenne" wrote in message
...
Is it possible to write code in excel so that when I open a certain
workbook,
it always opens to a specific sheet. I know if you save it on a specific
sheet, it will open there the next time, but I want to be able to save
anywhere in the workbook and have it open to "Sheet1" everytime.
--
Cheyenne
|