Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calling a macro from Worksheet--Activate
Hi-
I have a macro that I want to run when a worksheet is activated. Problem is I do not know how to call it. When I call a function (Let's say the name is FUNC1) within a macro I just type FUNC1. I am attempting the same idea on the macro and am having no success. I'm sure there is a simple solution to this that I am overlooking. Can someone please help me fill in the blanks?? Private Sub Worksheet_Activate() MACRO TO RUN HERE. HOW DO I CODE IT? End Sub Thanks! Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calling a macro from Worksheet--Activate
Private Sub Worksheet_Activate()
Call MacroToRunHere End Sub The Call is actually optional. I like to use it. But you could use: Private Sub Worksheet_Activate() MacroToRunHere End Sub Fatz wrote: Hi- I have a macro that I want to run when a worksheet is activated. Problem is I do not know how to call it. When I call a function (Let's say the name is FUNC1) within a macro I just type FUNC1. I am attempting the same idea on the macro and am having no success. I'm sure there is a simple solution to this that I am overlooking. Can someone please help me fill in the blanks?? Private Sub Worksheet_Activate() MACRO TO RUN HERE. HOW DO I CODE IT? End Sub Thanks! Chris -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calling a macro from Worksheet--Activate
On Mar 5, 5:42*pm, Dave Peterson wrote:
Private Sub Worksheet_Activate() * Call MacroToRunHere End Sub The Call is actually optional. *I like to use it. But you could use: Private Sub Worksheet_Activate() * MacroToRunHere End Sub Fatz wrote: Hi- I have a macro that I want to run when a worksheet is activated. Problem is I do not know how to call it. *When I call a function (Let's say the name is FUNC1) within a macro I just type FUNC1. *I am attempting the same idea on the macro and am having no success. I'm sure there is a simple solution to this that I am overlooking. Can someone please help me fill in the blanks?? Private Sub Worksheet_Activate() MACRO TO RUN HERE. *HOW DO I CODE IT? End Sub Thanks! Chris -- Dave Peterson- Hide quoted text - - Show quoted text - Thanks Dave. So if the macro is named MACRO1, all I type is MACRO1 and it will fire when the sheet is activated? Chris |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calling a macro from Worksheet--Activate
Maybe...
You could do some things that would cause it to fail. But I bet you wouldn't do those things! What happened when you did a simple test? Fatz wrote: <<snipped Thanks Dave. So if the macro is named MACRO1, all I type is MACRO1 and it will fire when the sheet is activated? Chris -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling macros from worksheet to another | Excel Discussion (Misc queries) | |||
Worksheet- activate macro | Excel Discussion (Misc queries) | |||
calling worksheet function from a macro | Excel Worksheet Functions | |||
calling up information from a different worksheet. | Excel Worksheet Functions | |||
calling macro in a formula | Excel Discussion (Misc queries) |