prevet users to view and modify MS query

[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

 

[Tom Ogilvy]

why not provide the user a button to click. The button runs code to
unprotect the sheet, refresh the data, reprotect the sheet.

 

[Don Guillett]

Maybe you could use a macro to create the query>get the data>delete the
query name. Protect the macros.