Control property change using VBA
Do you men if you hide the rows the spinner is in it doesn't hide with the
rows? It did in my tests.
Make sure that the 'Move and Size with cells' button is set on the
Properties tab if you right-click the spinner and choose Format Control.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Steve" wrote in message
...
I am using a form control 'Spinner' to change the value of a set cell. The
problem is I am using a VBA control to make areas of the sheet invisible,
but
I can't get the 'spinner' to become invisible, and there for hidden from
users who don't need to use that control. Can anyone please enlighten me.
Thanking you in advance for any and all help
Steve
|