Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Rum macro in procedure

Hi guys.

I have to call a macro (macro2) from wthin "Private Sub
Worksheet_Activate()"

How can i do this?

Thanks!!!
SpeeD
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Rum macro in procedure

Thanks a lot!

By the way if i want to run a macro from a "IF" formula
in a cell, how can i do it??

Thanks!!!!!


-----Original Message-----
Private Sub Worksheet_Activate()
macro2
end Sub

--
HTH
Richard Choate, CPA
"SpeeD" wrote in message
...
Hi guys.

I have to call a macro (macro2) from wthin "Private Sub
Worksheet_Activate()"

How can i do this?

Thanks!!!
SpeeD


.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Rum macro in procedure

IF cell (a,b) = ... THEN
Call macro
END IF

"SpeeD" wrote in message
...
Thanks a lot!

By the way if i want to run a macro from a "IF" formula
in a cell, how can i do it??

Thanks!!!!!


-----Original Message-----
Private Sub Worksheet_Activate()
macro2
end Sub

--
HTH
Richard Choate, CPA
"SpeeD" wrote in message
...
Hi guys.

I have to call a macro (macro2) from wthin "Private Sub
Worksheet_Activate()"

How can i do this?

Thanks!!!
SpeeD


.



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Rum macro in procedure

Hi

I´ve tried to write this formula in a cell (c17), but
simply doens´t work. What am i missing??

thanks!
SpeeD


-----Original Message-----
IF cell (a,b) = ... THEN
Call macro
END IF

"SpeeD" wrote in message
...
Thanks a lot!

By the way if i want to run a macro from a "IF" formula
in a cell, how can i do it??

Thanks!!!!!


-----Original Message-----
Private Sub Worksheet_Activate()
macro2
end Sub

--
HTH
Richard Choate, CPA
"SpeeD" wrote in message
...
Hi guys.

I have to call a macro (macro2) from wthin "Private

Sub
Worksheet_Activate()"

How can i do this?

Thanks!!!
SpeeD


.



.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Rum macro in procedure

You can't do that directly from a formula, but you can code it to
happen based on a set of conditions. What conditions do you want to
cause this macro to fire?


On Thu, 7 Aug 2003 06:22:02 -0700, "SpeeD72"
wrote:

Hi

I´ve tried to write this formula in a cell (c17), but
simply doens´t work. What am i missing??

thanks!
SpeeD


-----Original Message-----
IF cell (a,b) = ... THEN
Call macro
END IF

"SpeeD" wrote in message
...
Thanks a lot!

By the way if i want to run a macro from a "IF" formula
in a cell, how can i do it??

Thanks!!!!!


-----Original Message-----
Private Sub Worksheet_Activate()
macro2
end Sub

--
HTH
Richard Choate, CPA
"SpeeD" wrote in message
...
Hi guys.

I have to call a macro (macro2) from wthin "Private

Sub
Worksheet_Activate()"

How can i do this?

Thanks!!!
SpeeD


.



.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invalid outside procedure (creating a PDF button as a macro) Neall Excel Worksheet Functions 0 April 30th 09 03:44 PM
Stop a Procedure from another procedure Ayo Excel Discussion (Misc queries) 1 October 30th 08 01:42 AM
hyperlink, macro, stored procedure? JICDB Excel Worksheet Functions 5 October 27th 07 12:18 AM
start a macro or procedure based on user putting an x in a cell mathew Excel Discussion (Misc queries) 0 August 17th 06 06:21 PM


All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"