Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro button on/off
Hello all, I have created a box with a macro assigned to it that will
highlight the cells that have changed from one tab to the other. When I click on this box the macro runs but I would also like to be able to click it off. Could someone please help me with this? I have copied the code below that has been used so far in case that helps. Thanks. Sub auditt() Dim sh1 As Worksheet, sh2 As Worksheet Set sh1 = Sheets("Original") Set sh2 = Sheets("Final") For Each r In sh1.UsedRange v1 = r.Value rr = r.Row cc = r.Column v2 = sh2.Cells(rr, cc).Value If v1 < v2 Then sh2.Cells(rr, cc).Interior.ColorIndex = 36 End If Next End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro button on/off
What kind of box? Is it just a shape? Is it a UserForm? Is it a control
from the control tool box? A box doesn't do much for me. I need a definition that fits the VBA conventions. "Peter" wrote: Hello all, I have created a box with a macro assigned to it that will highlight the cells that have changed from one tab to the other. When I click on this box the macro runs but I would also like to be able to click it off. Could someone please help me with this? I have copied the code below that has been used so far in case that helps. Thanks. Sub auditt() Dim sh1 As Worksheet, sh2 As Worksheet Set sh1 = Sheets("Original") Set sh2 = Sheets("Final") For Each r In sh1.UsedRange v1 = r.Value rr = r.Row cc = r.Column v2 = sh2.Cells(rr, cc).Value If v1 < v2 Then sh2.Cells(rr, cc).Interior.ColorIndex = 36 End If Next End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
Creating a macro which presses a button containing a recorded macro | Excel Programming | |||
Can't select macro button after other button is pressed | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming |