Set active worksheet on startup
 

I have a excel file with several worksheets. I would like to ensure that a
specific worksheet is the active worksheet every time a user opens the file.

Thanks in advance for any help.

Set active worksheet on startup
 

Use the ThisWokbook module; open it and use the comboboxes three to navigate
to the Open event (go from "(General) -- (Declarations)" to "Workbook --
Open". Excel will create a stub for you like the one below. All you need to
add is one line, also as shown.

------------------------------------------
Private Sub Workbook_Open()
Worksheets("YourSpecialSheetName").Activate
End Sub
------------------------------------------

"Duplicate entries" wrote in
message ...
I have a excel file with several worksheets. I would like to ensure that a
specific worksheet is the active worksheet every time a user opens the
file.

Thanks in advance for any help.