• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

object browser

D

delta

Member
i use office 2007
how to put code in object browser for sheet activate event for sheet 1 .


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum ‼
​
 
Last edited by a moderator:
Hello delta.

There are various ways to activate your worksheet.

Code: 
1)  Sheet1.activate
2)  Worksheets("Sheet1").activate
3)  Worksheets(1).Activate

or you can set your worksheet as object and activate instead of referring your sheet name like.

Sub test()
dim sht as worksheet
set sht=Worksheets("Sheet1")
Sht.Activate
end sub
 
You must log in or register to reply here.
Back
Top