Cut or Hid control buttons

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!

Hi,
as far as I know it is possible to hide the button for print in its properties. Then you can print it in pdf and attach to email too. So it is one optioin.

The second one is to set property visible=false for all object in shape collection by macro.

I use the third option: I make a white rectangular to cover all buttons in sheet and set it's order to "move to back". Then I create button (also in area of prepared white rectangular) and write a simple routin for it: this button just select the rectangular and set it's order to "bring to front". See attached file.
Let me know if it works. Regards
Petr

The third option will not work for me. I actually need to have the buttons gone. The VBA code to change the visibility would work, not just a macro. I am going to run this from a user form. How would I set that up? I have a lot of different buttons the set this for but if you could show a sample for just 1, I can modify it for what I need.

Thanks.

Hi, use this:

Please Login or Register  to view this content.

Regards
Petr