Protecting a Microsoft Query

[Guest]

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.

 

[NickHK]

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