View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Andrew is offline
external usenet poster
 
Posts: 28
Default initial worksheet

If a Workbook has 3 Sheets and you want sheet 2 to be the initial sheet ...

In VB, Double click ThisWorkbook, then click on the dropdown, select
Workbook,
should automatically go to Open event, and create it. if not select Open
in Right hand Dropdown


Private Sub Workbook_Open()
Worksheets("Sheet2").Activate ' Add whichever sheets Name you want to
become Active when the workbook opens
End Sub


HTH
Andrew


"Miqueias Lucas" wrote in message
...
| dear classmate!...
|
| Wow can i define same worksheet as initial worksheet at my excel project?
|
|
| --
| Miqueias Lucas - Analista/Programador de sistemas