Button Control Moving
 

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

Button Control Moving
 

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