M
Mike
I'm working on a new employee scheduling project. So far
I have a dozen sheets, and I was developing an error check
sheet to ensure valid scheduling was in place. This sheet
is nothing but formulas, but for some reason, I started
getting an error #1004 (application defined or object
defined error). It seems that every time I click on the
space between column headers on any sheet, the
Combobox1_Change event for another sheet is being
triggered twice. It doesn't happen if I resize the
column. I have no code triggering this event. I can
bypass the error by checking for the activesheet name in
the combobox click event, but I shouldn't have to do this,
since the event isn't triggered by anything that happens
on another sheet.
I have a dozen sheets, and I was developing an error check
sheet to ensure valid scheduling was in place. This sheet
is nothing but formulas, but for some reason, I started
getting an error #1004 (application defined or object
defined error). It seems that every time I click on the
space between column headers on any sheet, the
Combobox1_Change event for another sheet is being
triggered twice. It doesn't happen if I resize the
column. I have no code triggering this event. I can
bypass the error by checking for the activesheet name in
the combobox click event, but I shouldn't have to do this,
since the event isn't triggered by anything that happens
on another sheet.