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 Pivot Table to user. However, I don't want let
them read the SQL Query and Connection String using the Edit Query in Excel.
Therefore, how can I disable this Edit Query Function or clear all
information. Also, can I disable the Refresh buitton too?

Please help.