I have an excel spreadsheet that I use to generate a report. There are some button on the sheet that I use while making my report but I need to get rid of when I email or print my report.

Is there a way to have a button on a separate sheet control if the buttons are visible or not? Such as one that simply says "Hide / Unhide Buttons" and when it is clicked the button hide if they are currently present or unhide if currently hidden.

If not, how would I add a line of code to my VBA that cuts the buttons out of the report when I click another button on a form?

Thanks!