Disable Edit Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Peter Sze said:
What you means?
Click to expand...

I mean, is there a particular reason for mentioning that you are using
VB.NET? You could've said, 'I am generating a Pivot Table using code'
and I would've assumed you were using VBA but that would have no
significance. The fact you mentioned VB.NET makes me wonder if it has
implications to the way you are doing things. For example, if you are
using Visual Studio Tools for Office (VSTO) then I'd attach no
significance.

Jamie.

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
EDITTING QUERIES RELATED TO QUERY TABLE 1
prevet users to view and modify MS query 2
How to modify the sql statement on a pivot table using VBA- XL2000 1
Excel + Query Tutorial Recommended? 1
MS Query has data, but does not transfer it to Excel 2
MS Query problem 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top