Export hidden objects to PPT using macro

[sagarkharpude]

Hi Folks,

I want to export hidden objects to PPT by using macros. I have written the macro for export to ppt. But after hiding the objects i could not able to export the objects to ppt.

Can you please help me.

Thanks

[jonathandienst]

I think the problem is QV does not re-calculate hidden objects. So if the object is never visible, it will not be generated and cannot be exported.

[sagarkharpude]

Hi Jonathan,

Thanks for reply. IS it possible to export the object of hidden sheets.

[jonathandienst]

Same problem, I think. You may be able to make the object visible, wait for idle, export and then hide the object again in your script. You may be able to find such a script if you search the community.