ive tried _Change and _Calculate, neither has worked. they just wont
trigger for some reason.

Has Application.EnableEvents been left 'False' by some process that
threw an error?

I'm not sure, would I need to just declare this as true in the function to change it if it has been set to false?

unless it would need to be in the "ThisWorkbook" since its a live
update thing

Please explain! (You said/implied this was a cell dropdown containing
choices, which means a DV list!)?
I mean the actual code, does it need to be within the "ThisWorkbook" under The objects folder in the developer window?




--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion[/quote]