Can't create macro for deleting objects

[sperrysperry]

I can't create a macro to delete objects. Someone solved this one for me a while back. I'm in a different file, and can't get it to work. I tried creating the macro manually and in visual basic. Sub Del Object() ActiveSheet.DrawingObjects.Cut But neither method works. File attached.

[kersplash]

I don't see the macro you are referring to.

And maybe also attach the file that is working.

[sperrysperry]

The macro is in "Macros" on the main ribbon. Or in the "General" screen in visual basic. It is called RemoveObjects. I have re-attached the file. There are three macros. Two (the two that have buttons) work fine. But I can't get the one to remove objects to work.... either my creating it manually in Excel or with visual basic. I no longer have the file that worked.

[kersplash]

Try adding the line;

Please Login or Register  to view this content.

to your code.

[sperrysperry]

Nope. Got a "Runtime error '424'

[kersplash]

If you run the code without the delete line, do all the objects in the sheet get selected?

[sperrysperry]

Excellent question. I have tried it with and without "delete" and "cut," and neither work AT ALL... that is, nothing is even selected. The earlier macro that "worked" didn't completely work. It went as far as selecting and I had to hit "backspace." Now I can't even get it to do that. I know it's just a few keystrokes via F-5, but I was hoping to string the three macros together, and do all the work with one button. Thanks for working on this with me.

[kersplash]

But maybe you are trying to run it when there are NO objects available to select, therefore error.

Place an object and then try the code.

[sperrysperry]

I checked. There are plenty of objects. I also tried selecting the entire sheet (excel macro) to no avail.