Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: drewdb on September 07, 2008, 06:26:32 PM

Title: Auto Ungroup
Post by: drewdb on September 07, 2008, 06:26:32 PM
Hi to all again,

Is there a command within the shapesheet to ungroup a master?

I have a master that is made up of other masters and i would like it to ungroup on the drop event hopefully without using VBA. I've seen how to do it with VBA but i would prefer the shapesheet if i can.

Title: Re: Auto Ungroup
Post by: wapperdude on September 07, 2008, 07:03:20 PM
My first guess is No, not in the shapesheet.  But, if you have vba code, you might try executing it by adding the Runaddon function in the EventDrop cell of the Events section.  It might work.  The problem that I see, as soon as you ungroup, the shapesheet for that group vaporizes!  Worth a try.

Title: Re: Auto Ungroup
Post by: drewdb on September 07, 2008, 07:33:46 PM
Thanks for that. I was hoping to avoid VBA on this one.

The master doesn't have any shape data or shapesheet info but each sub shape does. Once i drop it on the drawing i can select ungroup and it reveals everything but i'm hoping to make this auto to the user without VBA.

Thanks again, i'll keep looking
Title: Re: Auto Ungroup
Post by: Lars-Erik on September 08, 2008, 01:06:25 AM
You can't do this without code...

You said you saw how to do it with code, I would still like to point to the following topic, just in case:

- Lars
Title: Re: Auto Ungroup
Post by: Visio Guy on September 08, 2008, 04:49:08 AM
This formula will also work, to some extent.

EventDrop = DOCMD(1052)

You will still be asked; "Do you want to sever the instance from the master", because ungrouping an instance on the page kills all inheritance from the master shape. This warning message can be strange and scary to novice users, so you will want to be sure and explain it to them in advance.

Also, I have a video of a prototype "assembly dropper" that I was thinking about developing--if the right amount of interest/funding were to come along.

See this link: Dropping Predefined Shape Assemblies (
Title: Re: Auto Ungroup
Post by: drewdb on September 09, 2008, 05:59:53 PM
Thanks for that guys.

I feared that it was not possible in the ShapeSheet but worth an ask anyway.
Your link Lars-Erik, was in fact the one that I saw and went with, I don't want the users to get the warning message.

I'm still learing but I hope I can contribute here one day.