Is there any way to group objects???

[#1]

Hi Friends,

Is there any way to group objects for example pivot charts and use the group ID to write a macro or to give similar properties to the group???

Thanks

[AbhijitBansode]

Container object can be used to group different sheet objects.

However, properties of each object needs to set independently.

[agomes1971]

Hi,

nop...

Still waiting for the ability to group objects...

Regards

André Gomes

[AbhijitBansode]

If you want to group similar type of objects then you can use linked object feature.

Make ObjectId of all the pivot charts similar, then they will share same set of properties.

You can also create link object by simply copying object and then using the option "Paste Sheet Object as Link"

refer attached for Linked Object description

[avinashelite]

Hi Pavan,

Container would be the better option, try with it

[#6]

I too Agree cabhijit

Container object is the option for this.

[agomes1971]

Hi,

container it's the only choice.

Regards

André Gomes