Macro Command Buttons

[Mike]

Hi Guys,
Just done a load of macros with command buttons placed in
various positions.
When I use print area to define a print range, all the
buttons group on the left hand side !!
Any suggestions most welcome ... I've set them to don't
move or resize through the format menu.

Regards Mike ...

 

[Dave Peterson]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

might be it.

 

[icestationzbra]

i have a similar issue of all these controls running for cover when
run the 'reset-last-cell' macro. also, the buttons become very small a
the end of the storm.

what gives

 

[Mike]

Many thanks Dave ...
mike

-----Original Message-----
http://support.microsoft.com/default.aspx?scid=kb;EN- US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

might be it.


--

Dave Peterson
(e-mail address removed)
.

 

[Dave Peterson]

My bet is that if you rightclick on your control and select Format control, then
Properties, you don't have it set for "don't move or size with cells".

If it's set for "move and size with cells" and I delete columns/rows, then I get
the same thing you get.