I have a macro attached to an combo box on an Excel worksheet. The macro calls two other macros which hide/unhide rows and update a graph:
Private Sub ComboBox1_Change()
Application.ScreenUpdating = False
CompareGraph
GraphColors
Application.ScreenUpdating = True
End Sub
For some reason anytime I do anything in the workbook (even on other sheets) the macros are running. This has happened when I add/delete rows and just changed text in a cell.
Any ideas why this might be happening?
Many thanks in advance!
Private Sub ComboBox1_Change()
Application.ScreenUpdating = False
CompareGraph
GraphColors
Application.ScreenUpdating = True
End Sub
For some reason anytime I do anything in the workbook (even on other sheets) the macros are running. This has happened when I add/delete rows and just changed text in a cell.
Any ideas why this might be happening?
Many thanks in advance!