Hide Pages
 

I am using a pivot table to generate graphs in a userform by creating
an OWC chart. I would like to hide the page with the pivot table, but
if I do the sub that creates the OWC chart can't find the data. Is
there a way to hide worksheets from users but not from VBA?

Thanks so much for your help

cr