Buttons Moving around page or shrink in size on Excel Worksheets

Buttons Moving around page or shrink in size on Excel Worksheets

Post by amdlaHJ » Sun, 19 Jun 2005 02:28:17


When I use Buttons to control the operation of Macros I experience the
following problems:

1) The buttons grow or shrink as they are activated?
2) When I ditribute the sheets to other users, same release of op sys and
Excel the buttons randomly move around the sheets ruining the format of the
page. This often occurs when setting up to print the sheet from a macro?

All machines are on XP or XP pro and Excel 2004

Thanks for any help,

John
 
 
 

Buttons Moving around page or shrink in size on Excel Worksheets

Post by bhofset » Sun, 19 Jun 2005 03:21:29


Go into design mode and right click your buttons.
Select 'Format Control'
Then on the Properties tab select the "Don't move and size with cells
radio button

 
 
 

Buttons Moving around page or shrink in size on Excel Worksheets

Post by Norman Jon » Sun, 19 Jun 2005 04:29:17

Hi John,

See MSKB Article # 838910 (Controls move to the left of the worksheet in
Microsoft Excel 2002)

http://www.yqcomputer.com/ ;EN-US;838910


---
Regards,
Norman