i am having sliders, barcharts in my sheet. I need to make detach the sliders, barcharts when clicking on button.
the button should contain the fuctionality of detaching all the sliders, barcharts in sheet.
Can anyone help in this doubt.
You can use the following macro applied to an action in the button properties to detach an object:
Sub DetachGraph ActiveDocument.GetSheetObject("CHXX").Detach '' Change CHXX for your barchart IDEnd Sub
Sliders cannot be detached.
Hope that helps
Retrieving data ...