Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to run or not run a second Macro
Howdie! I need to run a macro that, depending on the result in a cell, runs another Macro (second macro is just a hide of a column) So for example, when the user runs Macro 1 it needs to check the value in Cell A1. If A1 = Yes, then run Macro number 2. If the value in a1 = No, then dont run any Macros and the first macro can be stopped. Any ideas? Thanks and Regards Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to run or not run a second Macro
Hi Darin
Use this Sub macro1() If Sheets("sheet1").Range("A1").Value = "Yes" Then macroname End If End Sub Sub macroname() MsgBox "H1" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Darin Kramer" wrote in message ... Howdie! I need to run a macro that, depending on the result in a cell, runs another Macro (second macro is just a hide of a column) So for example, when the user runs Macro 1 it needs to check the value in Cell A1. If A1 = Yes, then run Macro number 2. If the value in a1 = No, then dont run any Macros and the first macro can be stopped. Any ideas? Thanks and Regards Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to run or not run a second Macro
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany "Darin Kramer" schrieb im Newsbeitrag ... Howdie! I need to run a macro that, depending on the result in a cell, runs another Macro (second macro is just a hide of a column) So for example, when the user runs Macro 1 it needs to check the value in Cell A1. If A1 = Yes, then run Macro number 2. If the value in a1 = No, then dont run any Macros and the first macro can be stopped. Any ideas? Thanks and Regards Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |