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.
 
Back
Top