VBA: If you want the cute button and rich flexibility of vBA
Just got to get the foundation in place (calls in shape, security settings for other users to use it).
Actions: Can use actions...not as pretty, but relatively simple
in shapesheet of shape, insert actions section
actions.show_hide = setf(getref(actions.show_hide), if (actions.show_hide.checked,0,1)
actions.show_hide.label = "hide shape"
Geometry<x>.noshow = if(actions.show_hide.checked,0,1)
to use, right click shape...click on the "hide shape"
now if you want to make it more usable, add another shape as the buttom and group them
you can use that button shape to control hiding the real shape.
actions in the button shape E.g. in sheet.2!actions.show_hide
geometry<x>.noshow in shape e.g. in sheet.1....if(sheet.2!actions.show_hide.checked,0,1)
VBA more flexible but got to deal with security settings
Actions less VBA overhead but harder to extend for other things...if that is the goal