Buttons Moving around page or shrink in size on Excel Worksheets
 

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
 

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

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38017

Buttons Moving around page or shrink in size on Excel Worksheets
 

Hi John,

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

http://support.microsoft.com/default...b;EN-US;838910


---
Regards,
Norman



"jgehrt" wrote in message
...
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