Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 252
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 324
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to stop a Control Button moving when I delete columns(Excel) CH-DE-FDS APRIL Excel Discussion (Misc queries) 2 October 28th 08 10:08 AM
Need ComboBox to require entry before moving to next control JennLee Excel Programming 7 May 4th 08 05:21 AM
Prevent user moving to next control johncassell[_11_] Excel Programming 7 July 31st 05 08:12 PM
Moving a control in a userform Pierre Archambault Excel Programming 2 November 22nd 04 02:21 PM
Command Button vs Control Button RGibson Excel Programming 1 October 14th 03 02:24 AM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"