How do I hide an excel sheet 1

[LonnieJohnson]

I have an access module that creates an excel workbook with two sheets, a pivot table and a graph. I would like to hide the pivot table. Is that possible from my access code?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[PHV]

yourExcelObject.Worksheets("sheet name").Visible = False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LonnieJohnson]

Thanks.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!