PDA

View Full Version : OPEN TO SPECIFIC SHEET



sivadnitram
09-17-2008, 09:10 AM
GOOD EVENING ALL,

I AM SURE THERE IS A SIMPLE SOLUTION TO MY PROBLEM BUT I CANNOT FIND IT. I WANT MY WOOKBOOK ALWAYS TO OPEN TO THE SHEET NAMED "FOREPIECE" . IT DOSN'T SEEM TO MATTER WHAT SHEET I AM ON WHEN I CLOSE THE WORKBOOK IT ALWAYS RE-OPENS ON A SHEET NAMED "FRONT". ANY HELP WILL BE GREATLY RECIEVED. THANK YOU
SIVADNITRAM

Bob Phillips
09-17-2008, 09:12 AM
Private Sub Workbook_Open()
Me.Worksheets("FOREPEICE").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

sivadnitram
09-17-2008, 11:15 PM
Good Morning,
Many thanks for that. It is exactly what i nedd
Regards
sivadnitram