Control property change using VBA
 

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

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

Control property change using VBA
 

Thats one way yes, but if I do that then other section that are inportant to
the sheet get hidden when they need to be visible. I just need to be able to
click the VBA control and the Form Control 'spinner' becomes invisible.

Thank you any way though, your help is appreciated


"Bob Phillips" wrote:

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