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.

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.

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