Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Microsoft Query
I am inporting data using a query.
Is there a way of protecting that query so a user cannot modify it? It appears that anyone can go to Dataedit query and change it. Thanks - Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Microsoft Query
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Microsoft Query
Don
Protecting the sheet will protect the query. Tools - Protection - Protect Sheet. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Don" wrote in message ... I am inporting data using a query. Is there a way of protecting that query so a user cannot modify it? It appears that anyone can go to Dataedit query and change it. Thanks - Don |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Microsoft Query
Thanks - However, I stil need them to be able to refresh
the data. Protecting the sheet disables that command. Thanks - Don -----Original Message----- Don Protecting the sheet will protect the query. Tools - Protection - Protect Sheet. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Don" wrote in message ... I am inporting data using a query. Is there a way of protecting that query so a user cannot modify it? It appears that anyone can go to Dataedit query and change it. Thanks - Don . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Microsoft Query
Not yet.
I don't care if the user manipulates the data, I just don't want them to change the query. -----Original Message----- Have you had any luck with this?? --- Message posted from http://www.ExcelForum.com/ . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Microsoft Query
Don
Two options that I see. You can disable all the ways that the user can get to edit query. Consider putting this in the sheet activate event and then re-enable them in the sheet deactivate event Dim cbcs As CommandBarControls Dim cbc As CommandBarControl Set cbcs = Application.CommandBars.FindControls(, 1950) For Each cbc In cbcs cbc.Enabled = False Next cbc Another option is to code your own Refresh button and protect the sheet. The regular Refresh button, along with the Edit Query button, will be disabled and the user will have to use your Refresh button. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Don" wrote in message ... Thanks - However, I stil need them to be able to refresh the data. Protecting the sheet disables that command. Thanks - Don -----Original Message----- Don Protecting the sheet will protect the query. Tools - Protection - Protect Sheet. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Don" wrote in message ... I am inporting data using a query. Is there a way of protecting that query so a user cannot modify it? It appears that anyone can go to Dataedit query and change it. Thanks - Don . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Microsoft Query
Thanks - I will try those
-----Original Message----- Don Two options that I see. You can disable all the ways that the user can get to edit query. Consider putting this in the sheet activate event and then re-enable them in the sheet deactivate event Dim cbcs As CommandBarControls Dim cbc As CommandBarControl Set cbcs = Application.CommandBars.FindControls(, 1950) For Each cbc In cbcs cbc.Enabled = False Next cbc Another option is to code your own Refresh button and protect the sheet. The regular Refresh button, along with the Edit Query button, will be disabled and the user will have to use your Refresh button. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Don" wrote in message ... Thanks - However, I stil need them to be able to refresh the data. Protecting the sheet disables that command. Thanks - Don -----Original Message----- Don Protecting the sheet will protect the query. Tools - Protection - Protect Sheet. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Don" wrote in message ... I am inporting data using a query. Is there a way of protecting that query so a user cannot modify it? It appears that anyone can go to Dataedit query and change it. Thanks - Don . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
Microsoft Query and IIf | Excel Discussion (Misc queries) | |||
Microsoft Query | Excel Discussion (Misc queries) | |||
Microsoft Query | Excel Worksheet Functions | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) |