Command button moves during printing

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Please help:

The code below is within a printing subroutine. This
sub is triggered by clicking on a command button located
on Sheet 1 within a spreadsheet.

When the printing is occurring, the command button
moves 19 columns to the left. The Save function, which
occurs before the printing occurs, keeps this change from
being saved.

Why does the command button move in the first place,
and how can I prevent this unsightly occurrence?

Thank you.


ActiveWorkbook.Save
Sheets("Sheet1").Select
Range("A1:W54").Select
Selection.PrintOut Copies:=1, Collate:=True
Application.DisplayAlerts = False
ActiveWindow.Close
End Sub
 
If you do not want the button to be printed, in Tools >
Options > View, checkmark Hide all placeholders. Do this
with the code, then when print has been sent, unhide the
button.

Also see the properties of the button. Don't move with
cell.

regards
Mark
 
Back
Top