Command Button won't sit still.

[pubert]

I have an excel workbook with many worksheets. Each sheet
has 2 command buttons. When I run VBA Macros that redraws
the print area or change sheets the command buttons slide.
How do I lock them down?
..

 

[Anne Troy]

Try right-click and format object, properties tab, then tell it not to move
with cells.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[Guest]

That is set and it still slides around when the sheet is
redrawn, Any other suggestions?