Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a macro when a Worksheet is clicked/activated
Hi,
I'm looking for code that runs a macro when a worksheet called "email" is clicked everytime. I think it's an event macro, but, I can not seem to find an example. The macro I want to run is simple Sheets("email").Select Range("A1").Select Application.CutCopyMode = False ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 Thanks in advance. Wazza McG |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a macro when a Worksheet is clicked/activated
Rightclick on the Email sheet tab and select "View Code".
From the drop down boxes above select Worksheet (from the left) and Activate (from the right). This should create a procedure for you thus: Private Sub Worksheet_Activate() End Sub Insert your code here in there e.g. Private Sub Worksheet_Activate() msgbox "I'm clicked" End Sub It will then fire every time the worksheet is activated. If that Activates isn't what you're after, try Worksheet_SelectionChange or maybe a combination of the two. HTH, Gareth Warren McGoldrick wrote: Hi, I'm looking for code that runs a macro when a worksheet called "email" is clicked everytime. I think it's an event macro, but, I can not seem to find an example. The macro I want to run is simple Sheets("email").Select Range("A1").Select Application.CutCopyMode = False ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 Thanks in advance. Wazza McG |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a macro when a Worksheet is clicked/activated
Thankyou Thankyou Thankyou
Gee that was simple! Much appreciated, I have never used those View Code sheets before - great stuff. Wazza McG "Gareth" wrote in message ... Rightclick on the Email sheet tab and select "View Code". From the drop down boxes above select Worksheet (from the left) and Activate (from the right). This should create a procedure for you thus: Private Sub Worksheet_Activate() End Sub Insert your code here in there e.g. Private Sub Worksheet_Activate() msgbox "I'm clicked" End Sub It will then fire every time the worksheet is activated. If that Activates isn't what you're after, try Worksheet_SelectionChange or maybe a combination of the two. HTH, Gareth Warren McGoldrick wrote: Hi, I'm looking for code that runs a macro when a worksheet called "email" is clicked everytime. I think it's an event macro, but, I can not seem to find an example. The macro I want to run is simple Sheets("email").Select Range("A1").Select Application.CutCopyMode = False ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 Thanks in advance. Wazza McG |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a macro when a Worksheet is clicked/activated
You're welcome!
Wazza McG wrote: Thankyou Thankyou Thankyou Gee that was simple! Much appreciated, I have never used those View Code sheets before - great stuff. Wazza McG "Gareth" wrote in message ... Rightclick on the Email sheet tab and select "View Code". From the drop down boxes above select Worksheet (from the left) and Activate (from the right). This should create a procedure for you thus: Private Sub Worksheet_Activate() End Sub Insert your code here in there e.g. Private Sub Worksheet_Activate() msgbox "I'm clicked" End Sub It will then fire every time the worksheet is activated. If that Activates isn't what you're after, try Worksheet_SelectionChange or maybe a combination of the two. HTH, Gareth Warren McGoldrick wrote: Hi, I'm looking for code that runs a macro when a worksheet called "email" is clicked everytime. I think it's an event macro, but, I can not seem to find an example. The macro I want to run is simple Sheets("email").Select Range("A1").Select Application.CutCopyMode = False ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 Thanks in advance. Wazza McG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO ACTIVATED AYTOMATICALLY | Excel Discussion (Misc queries) | |||
MACRO ACTIVATED EVERY 5 SECONDS | Excel Discussion (Misc queries) | |||
User Form activated by a macro | Excel Programming | |||
How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming | |||
Is there a way to know when a worksheet has been clicked? | Excel Programming |