Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macros Running Automatically

Status
Not open for further replies.

Duffymk

Programmer
Sep 28, 2001
6
GB
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!
 
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!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top