ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   initial worksheet (https://www.excelbanter.com/excel-programming/340612-initial-worksheet.html)

Miqueias Lucas

initial worksheet
 
dear classmate!...

Wow can i define same worksheet as initial worksheet at my excel project?


--
Miqueias Lucas - Analista/Programador de sistemas

Andrew

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




All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com