View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Sze[_2_] Peter Sze[_2_] is offline
external usenet poster
 
Posts: 3
Default Disable Edit Query

I am using VB.NET to generate the Pivot Table Report to user, and I set the
connection string and SQL query to Pivot Cache. However, I don't know how can
I disable the Edit Query function in Excel that not allow user to read the
connection string amd SQL. Or how to clear all information in this output.
Also, can I disable the Refresh button too?

Please help!