prevet users to view and modify MS query
 

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

prevet users to view and modify MS query
 

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

--
Regards,
Tom Ogilvy


"Jirka" wrote:

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

prevet users to view and modify MS query
 

Maybe you could use a macro to create the queryget the datadelete the
query name. Protect the macros.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jirka" wrote in message
...
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