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

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.

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

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.

"CleveCoop" wrote in message
...
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.

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

On May 17, 8:32 am, "Fred Smith" wrote:
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.

"CleveCoop" wrote in message

...

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.

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