prevet users to view and modify MS query

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
 
T

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.
 
D

Don Guillett

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

Top