View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default 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