| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I find out property values for each control object? | Excel Discussion (Misc queries) | |||
| changing an activex control property using a macro | Excel Discussion (Misc queries) | |||
| Object Postioning property not available for control | Excel Programming | |||
| Programatically control picture property of Image control | Excel Programming | |||
| (Name) Property Under VBA Control | Excel Programming | |||
Linear Mode
