ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how can i define initial worksheet (https://www.excelbanter.com/excel-programming/340611-how-can-i-define-initial-worksheet.html)

Miqueias Lucas

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

Dave Peterson

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


All times are GMT +1. The time now is 04:37 PM.

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