Hello Excel gurus...

So in my continual pursuit to create puzzles and games, I have simple WMF file that is comprised of 8 freeform objects.

What I'm having trouble with is getting the object ungrouped after it's loaded. (Manually ungrouping it works with no problem.)

I tried

Set myDocument = Worksheets(1)
For Each s In myDocument.Shapes
    s.Ungroup
Next
And get a "Run-time error '1004': This member can only be accessed for a group." message. But it is a group!

That code was taken right from the help file.

After it is ungrouped, I'll need to individually rename each of the 8 components within that group with a loop, based on its location within the grid. That's the easy part.

Does anyone have any ideas? Thank you in advance for you amazing help.

Mike