prevet users to view and modify MS query

  • Thread starter Thread starter Jirka
  • Start date Start date
J

Jirka

When I use MS query as external data-source for MS Excel 2003, how can I
prevent users to view and modify MS query or to view connection string
(username and password) to queried database. I would like to allow users only
to refresh data (or enable automatic data refresh once file.xls is open. (I
tried to protect spreadsheet, but it disables data refresh as well).Thanks
 
why not provide the user a button to click. The button runs code to
unprotect the sheet, refresh the data, reprotect the sheet.
 
Maybe you could use a macro to create the query>get the data>delete the
query name. Protect the macros.
 

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

query to external data 3
Auto Refresh Query Table 4
MS Query has data, but does not transfer it to Excel 2
refresh data from MS Access DB not picking up changes to criteria 2
Help, Query Refresh windowm appearing.... 2
Accept & Use ODBC Login 3
web query as background activity 1
Can I pass the logon credentials in a macro to a ODBC query 1

Back
Top