Protecting a Microsoft Query
 

Good morning,

I have an Excel file that links to an Access database to retrieve the
information via Microsoft Query. I want to protect the Microsoft Query from
the users going into it.

How do I protect my Microsoft Query from the users going in and messing
things up? I have a protection on the workbook "Structure". However, if the
user has an External Data toolbar, they can click on the Edit Query button to
go into the query.

Thanks.

Protecting a Microsoft Query
 

Protect the Worksheet instead/as well .
Depending on your code, you may need to add :

Worksheets(1).Unprotect "Password"
'Your code
Worksheets(1).Protect "Password"

NickHK

"Please Help" wrote in message
...
Good morning,

I have an Excel file that links to an Access database to retrieve the
information via Microsoft Query. I want to protect the Microsoft Query
from
the users going into it.

How do I protect my Microsoft Query from the users going in and messing
things up? I have a protection on the workbook "Structure". However, if
the
user has an External Data toolbar, they can click on the Edit Query button
to
go into the query.

Thanks.