Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi I am using Excel 2002, which there are 5 tabs (worksheets) in it and I want to place a code when the user switches to the first tab (worksheet). How do I do that? I just want to place a simply code to do a cell reference automaticlly when the first tab (worksheet) is pressed.. Any tips will be appreicated. Thank you in advance. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the code behind the first worksheet use a Worksheet_Activate event.
replace the MsgBox with whatever you wish to do on the worksheet now it is activated.... Private Sub Worksheet_Activate() MsgBox "I'm Here!" End Sub -- Cheers Nigel "Alex Martinez" wrote in message ... Hi I am using Excel 2002, which there are 5 tabs (worksheets) in it and I want to place a code when the user switches to the first tab (worksheet). How do I do that? I just want to place a simply code to do a cell reference automaticlly when the first tab (worksheet) is pressed.. Any tips will be appreicated. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Switching X and Y axis | Charts and Charting in Excel | |||
switching the worksheet? | Excel Discussion (Misc queries) | |||
Not switching to next worksheet | Setting up and Configuration of Excel | |||
selecting cell range in other worksheet without switching to worksheet | Excel Programming | |||
Prevent Users from switching worksheet | Excel Programming |