| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way multiple users can modify a document at the same t. | Excel Discussion (Misc queries) | |||
| Modify Spreadsheet View | New Users to Excel | |||
| How do I Modify The XML View Options | New Users to Excel | |||
| Users suddenly able to modify the same documents at the same time. | Excel Discussion (Misc queries) | |||
| Stop to modify the SQL query manually entered into query ! | Excel Programming | |||
Linear Mode
