Hey everyone,
I’m having trouble with a Google Sheets issue. There’s this drawing object in my spreadsheet that runs a macro when I left-click it. The thing is, I don’t need it anymore and want to get rid of it.
Problem is, I can’t seem to delete it! Left-clicking just runs the macro, and right-clicking doesn’t do anything at all. It’s like the object is stuck there.
Does anyone know how to remove these macro-linked objects? Is there some hidden menu or keyboard shortcut I’m missing?
I’ve tried looking through the menus and Google’s help pages, but no luck so far. Any tips would be super helpful!
Thanks in advance for any advice you can give!
I encountered a similar issue recently. The solution that worked for me was to access the spreadsheet from a different device or browser. For some reason, this bypassed the macro activation and allowed me to select and delete the object normally. If that doesn’t work, you might try making a copy of the sheet and deleting the object in the copy. As a last resort, you could contact Google Sheets support directly. They have access to more advanced troubleshooting tools and might be able to remove the object from their end.
I’ve dealt with this frustrating issue before. One trick that’s worked for me is temporarily disabling macros altogether. Go to Tools > Script editor, then in the script editor, choose View > Show manifest file. Look for the “runtimeVersion” key and change its value to “DEPRECATED”. Save and reload your sheet.
This should disable all macros, allowing you to delete the object. Once you’re done, remember to change the “runtimeVersion” back to its original value (likely “V8”) to re-enable macros.
If that doesn’t work, you could try opening the sheet in compatibility mode by adding ‘?rm=minimal’ to the end of your sheet’s URL. This often disables advanced features like macros, letting you manipulate objects freely.
Just remember to remove that parameter from the URL when you’re finished to restore full functionality.
hey alex, i’ve run into this before. try holding down the shift key while clicking the object. that should bypass the macro and let u select it normally. then hit delete or use the menu to remove it. hope this helps! lemme know if it works for ya