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.

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.