Activating a macro when a cell value goes to 1

frankday

Board Regular
Joined
Apr 13, 2012
Messages
102
I want to run a specific macro "Line129cal" when 1 is placed in cell "H127". I also want to run macro"Line129cal" when the bellow macro is run. "Toggle_601"

Sub Toggle_601()
If Rows("35:39").EntireRow.Hidden = True Then
Call Expand_601
Else
Call Callapes_601
End If
End Sub
 
Now I have it doing what I wanted. I have one last thing. Is there a way to prioritize macros. Here is the situation. I am working with one set of macros (we will call them #1 ) that lets say hides and unhides rows 35-45. Then I also have this macro that you helped me put together (we will call it Joe). I use your macro to hide row 38 Then when I run the macro #1 to unhide rows 35-45 it also unhides row 38. Is there something I can do to make it so macro Joe takes presidency over macro #1 so when I run macro #1 it doesn't unhide the work of Joe. Maybe when I run macro #1 it can also run macro Joe. Any ideas?
 
Upvote 0

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
It all depends on how you are calling the macros and how they interact.

You can call any macro from another macro using "Call" (except you typically would not call an Event Procedure macro, like Worksheet_Change). It looks like you already know how to do that.
So what exactly appears to be the issue?
What are the exact names of all the macros involved?
 
Upvote 0

Forum statistics

Threads
1,222,830
Messages
6,168,507
Members
452,194
Latest member
Lowie27

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top