Macros Running Automatically

[Duffymk]

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!

 

[SkipVought]

Hi,

Try using the ComboBox1_Click event instead of change.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Duffymk]

Thank you for the suggestion -

Problem was actually that I was adding lines/changing text to the cells that served as the combo box's list source. Not very smart of me!