View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
elaine elaine is offline
external usenet poster
 
Posts: 30
Default Pivot table - Hide the Data Sheet

Hi,

I created a pivot table from a data list. I want to show my client
the pivot table, but not the data which i generated the pivot table.
Is there a way to just send him my Pivot table, without letting him to
know what exactly is in the Data list? (like hiding the worksheet so
that he couldnt unhide it?... using a vba?)

Thanks very much.

Elaine