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!