Macro to export more than one Sheet objects into PPT

[#1]

Hi,

I am trying some scenarios in Qv objects export to PPT i have encountered some problems

I can succesfully export QV objects to PPT if i have single sheet.

now my series of issues appears where i cant able to Export to PPT

1) If i have buttons(with variables used to hide the charts)

2) if i have more than one sheet

Can any one suggest me how to export the objects to PPT from more than one sheet and the buttons which have the hide variables to show the chart

Here is the Sample App

[#2]

Suggestions required

[ecolomer]

Your file modified.

[#4]

Thanks Enrique for your response

but unfortunately i couldnot get the required solution from your sample

i am getting the following errror in the macros

"Shapes.Paste : Invalid request.  Clipboard is empty or contains data which may not be pasted here." and no object is shown in PPT

[#5]

HI

I could only see the following info in the PPT no sheet objects

i am attaching the screen shot of the PPT which i have got

do let me your suggestions !

[#6]

Suggestion required

[ecolomer]

See the image

[ecolomer]

Reload

[#9]

Thnaks

even in the app that u shared

we could able to see the objects from sheet Main sheet only not in the sheet1

kindly go through it

[ashfaq_haseeb]

Hi,

Check if this helps.

Regards

ASHFAQ