Forum Discussion
Sue_Ireland
Jul 17, 2021Copper Contributor
Macros - ActiveX command button
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 withi...
Sue_Ireland
Jul 18, 2021Copper Contributor
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 HansVogelaar
HansVogelaar
Jul 18, 2021MVP
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.
- Sue_IrelandJul 18, 2021Copper ContributorIt would not let me delete the file or even just exit out of it for quite some time. Eventually I was able to close it and then deleted it and re-created it from scratch. Seems like a time waster but I got through it the second time. Thank you for your help! It is appreciated.