Hello,
I am wondering if there is a way to setup a couple of objects (shapes) that appear in the middle of the screen any time the workbook is opened but be able to hide the object after making a selection?
For details:
I have a Shape in the middle of my spreadsheet that asks a yes or no question. Regardless of which button is pressed (yes or no) I would like the box along with the yes/no buttons to disappear. Once the person saves and closes I want the boxes to appear again if they reopen the workbook.
ie. If 'No' is pressed, nothing happens except the objects disappear
If 'Yes' is pressed a sub is run that created a new column, etc. and then the objects disappear
(Objects being two rectangle "buttons" over top of one large rectangle)
For aesthetic purposes I have used shapes as buttons (two rectangles over top of one large rectangle) instead of inserting the controls from the developer tab.
Thank you in advance for your help!
Bookmarks