Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
there is button control on my worksheet, it is supposed to fixed to a row but it move a liittle around when some row unhidden or hidden. Besides, it appears to be disabled even thought it is not. Clara -- thank you so much for your help |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
1. If the pointer changes to a hand when over the button:
Right-Click on the button and choose "Format Control". On the Properties tab you can select the way the button should respond to cell movements. 2. When the pointer remains in its normal form: Click on the Design mode icon. Then do number 1. -- Best wishes, Jim "clara" wrote: Hi all, there is button control on my worksheet, it is supposed to fixed to a row but it move a liittle around when some row unhidden or hidden. Besides, it appears to be disabled even thought it is not. Clara -- thank you so much for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to stop a Control Button moving when I delete columns(Excel) | Excel Discussion (Misc queries) | |||
Need ComboBox to require entry before moving to next control | Excel Programming | |||
Prevent user moving to next control | Excel Programming | |||
Moving a control in a userform | Excel Programming | |||
Command Button vs Control Button | Excel Programming |