View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Opening Workbook to a specific sheet

Put this tiny macro in the ThisWorkbook code area:

Private Sub Workbook_Open()
Sheets("qwerty").Activate
End Sub


to always open to sheet qwerty.
--
Gary''s Student - gsnu200714


"Carlee" wrote:

Hi there,
Can anyone tell me how I can open a workbook and display a specific sheet?
--
Carlee