On Wednesday, January 15, 2014 9:12:29 AM UTC-6, GS wrote:
IMO, any time you use buttons in hidden areas you can count on
unexpected behavior. I use cells that are formatted to
look/feel/behave like buttons so their position/appearance is
reliably consistent when the visibility of the area[s] they reside
is toggled.
I think I'll go your route next time. What a headache. I had to
control visibility, placement and naming. Hiding form controls, at
least buttons, is not something you want to do in Excel 2010. Never
again. Thank you
http://www.excel-ticker.com/position...in-excel-2010/
Wel.., this issue is not specific to v2010. It happens regularly in any
version if the controls are positioned in areas that hide/unhide
(however caused). I started using cells disguised as 'controls' when I
was working on a worksheet based wizard style form. Each pseudo-control
cell was given a local scope defined name that reflected its 'menu
caption', and their click was queried in the Selection_Change event of
the worksheet they were used on...
Select Case Target.Address
Case Range("btn1").Address: Call btn1Procedure
Case Range("btn2").Address: Call btn2Procedure
...
End Select 'Case Target.Address
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com