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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

losing command button functionality 4
Macro to restrict printing to black and white 2
command button moves 2
Print range & Command Button 3
UserForm Print Extra Copies 2
Macro (Print) - Calling Named Ranges 1
Printing of option buttons 1
Command Button Moves when sheet printed 2

Back
Top