I've often experienced many different (and unpredictable) results using
controls/shapes on worksheets when rows/cols need to be hidden or zoom
is changed. I've swithched to using worksheet events that manage
specific cells so as they look/behave like buttons or checkboxes. I use
conditional DV dropdowns for option selections where options are listed
but not enabled. Otherwise, the DV dropdowns are dependant on a list
which may or may not be dependant on another dropdown. Lots of work to
figure it all out but worth it in the end <IMO because my worksheet
forms behave as expected when I don't need to use Form/ActiveX
controls. Works very nice when you need a worksheet to behave like a
userform wizard!

--
Garry

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