Jul 16 2021 09:54 PM
Hi, I am seeking help on how to get rid of an ActiveX command button that I put in a worksheet and somehow I messed it up as I was trying to give it a label. Now, it will not let me do anything within the worksheet. I cannot delete the button, or even get out of the worksheet. Is there a way to get rid of this? Every time I click anywhere within the worksheet a box pops up and says "Reference isn't valid."
Jul 17 2021 12:36 AM
On the Developer tab of the ribbon, in the Controls group, click to highlight Design Mode.
Can you now select the button and delete it?
Jul 18 2021 11:39 AM
Hi,
When I am on the Developer Tab, none of the buttons are enabled. I cannot select any of them as they are all greyed out. I keep getting one of two different messages when I try to close the worksheet or click on anything, I either get "Reference isn't valid" or "Cannot Close Microsoft". I am new to doing this type of stuff on Excel as it is for a college program. I thank you for any and all help that you can provide on this matter.
Thank you,
Sue @Hans Vogelaar
Jul 18 2021 12:22 PM
You're probably best off by discarding this workbook and either going back to a backup copy from before the problem, or by re-creating it from scratch.
Jul 18 2021 01:03 PM