How do I keep a button size the same!

[Ted]

I am running several macros that import information from
another program via "command buttons". The information is
importing in to a pivot table that changes in width based
on the "garment size available" column. When I execute
the macros my buttons are changing sizes! Can I control
this?
Thanks in advance.

 

[William]

Hi Ted

1) Select a button causing a problem (or select them all at once)
2) Right click and select "Format Control"
3) Select the "Properties" tab and select "Don't move or size with cells"
4) Repeat 1) to 3) above for each button
--
XL2002
Regards

William

(e-mail address removed)

| I am running several macros that import information from
| another program via "command buttons". The information is
| importing in to a pivot table that changes in width based
| on the "garment size available" column. When I execute
| the macros my buttons are changing sizes! Can I control
| this?
| Thanks in advance.