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

dear classmater

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: 35,218
Default how can i define initial worksheet

You want it your workbook to always open to a specific worksheet?

If yes, put this in a general module:

Option Explicit
sub auto_open()
application.goto worksheets("sheet99").range("a1")
end sub

(Change sheet99 to the worksheet you want to be the initial worksheet.)

Miqueias Lucas wrote:

dear classmater

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

--
Miqueias Lucas - Analista/Programador de sistemas


--

Dave Peterson
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
VBA function to define name in a worksheet Clinton W[_2_] Excel Discussion (Misc queries) 2 May 12th 10 08:43 AM
Define Names Embedded in worksheet Karen Excel Discussion (Misc queries) 4 October 20th 08 05:51 PM
excel calls a worksheet that has initial row consisting of labels chava New Users to Excel 2 September 4th 07 08:07 PM
How to Define a named Formula at the Worksheet level? RPJ Excel Worksheet Functions 2 October 22nd 06 05:11 PM
How to take the worksheet name as a variable(Label/Define) in a fo Subin Excel Worksheet Functions 2 March 14th 06 12:43 PM


All times are GMT +1. The time now is 02:52 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"