Hi everyone,

I'm working in Excel 2003 and I have a workbook with a dropdown box on it.
In this particular situation the dropdown is disabled and not visible.

Where I have Calculate in my VBA or when I switch the calculation mode
between manual and automatic it seems the code thinks the dropdown box has
changed and it runs the code associated with such a change.

Any ideas?
TIA
big t

Generally we need to have a global variable that will skip the dropdow
code using something like :-


Code
-------------------
Sub DropDown1_Change()
If DropDownDisable = True Then Exit Sub
' other code
End Sub

-------------------


--
Message posted from http://www.ExcelForum.com

Put your event code in the click event rather than the change event.

--
Regards,
Tom Ogilvy

"big t" wrote in message
...
Hi everyone,

I'm working in Excel 2003 and I have a workbook with a dropdown box on it.
In this particular situation the dropdown is disabled and not visible.

Where I have Calculate in my VBA or when I switch the calculation mode
between manual and automatic it seems the code thinks the dropdown box has
changed and it runs the code associated with such a change.

Any ideas?
TIA
big t

thanks for your suggestions, i'll try them out...

cheers
big t


"big t" wrote:

Hi everyone,

I'm working in Excel 2003 and I have a workbook with a dropdown box on it.
In this particular situation the dropdown is disabled and not visible.

Where I have Calculate in my VBA or when I switch the calculation mode
between manual and automatic it seems the code thinks the dropdown box has
changed and it runs the code associated with such a change.

Any ideas?
TIA
big t