How do I remove a "Print Report" button embedded on spreadsheet?

C

CleveCoop

I have a button that sits on the spreadsheet that reads "Print Report". It
does not seem to function and it hides a couple of cells containing data. I
would like to remove the button or relocate it to another part of the
spreadsheet. I assume that it was intended to initiate a print macro or
something similar.
 
F

Fred Smith

Try the following:

1. Right click on the main Toolbar, and choose Customize...
2. Right click on the Print Report button, and choose Delete.
3. Close the customize toolbar window.

Make sure you exit Excel normally, so it will remember the new settings.

Regards,
Fred.
 
K

Ken Johnson

Try the following:

1. Right click on the main Toolbar, and choose Customize...
2. Right click on the Print Report button, and choose Delete.
3. Close the customize toolbar window.

Make sure you exit Excel normally, so it will remember the new settings.

Regards,
Fred.
Click to expand...

If Fred's method doesn't work then maybe View|Toolbars|Control Toolbox
to bring up the Control Toolbox Toolbar. Click on the Design Mode
button (ruler, pencil & set square image) to enter design mode, right
click the button obstructing the view then Cut it or just move it.

Ken Johnson
 
Top