Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default initial worksheet

dear classmate!...

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


--
Miqueias Lucas - Analista/Programador de sistemas
  #2   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove initial from end of name kswan Excel Discussion (Misc queries) 9 April 2nd 23 08:34 PM
excel calls a worksheet that has initial row consisting of labels chava New Users to Excel 2 September 4th 07 08:07 PM
Last initial Mike Rogers Excel Discussion (Misc queries) 14 January 28th 06 04:19 PM
Remove middle initial from "first name middle initial" Justin F. Excel Discussion (Misc queries) 15 September 26th 05 06:13 PM
how can i define initial worksheet Miqueias Lucas Excel Programming 1 September 20th 05 06:51 PM


All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"