So I have a named group of objects, and a worksheet_activate macro that hides/shows it based on certain conditions.
In a fit of stupidity, I edited the macro, deleting the hide/unhide line, and then promptly forgot the name of the grouped object. How do I get it back?!
Is there any way to conjure up a list of object names? I tried Shapes.ShowAll, but I got a runtime Out of Memory error (I have lots of memory, but I also have lots of objects on the sheet).
Anyone know of a solution?
In a fit of stupidity, I edited the macro, deleting the hide/unhide line, and then promptly forgot the name of the grouped object. How do I get it back?!
Is there any way to conjure up a list of object names? I tried Shapes.ShowAll, but I got a runtime Out of Memory error (I have lots of memory, but I also have lots of objects on the sheet).
Anyone know of a solution?