These two files have nothing to do with locking your project. They are
associated with the analysis toolpak and analysis toolpak - vba which are
shipped with excel and enabled by going into Tools=Addins and selecting
them (which it appears you have done).
--
Regards,
Tom Ogilvy
"Yian" wrote in message
...
Dear,
when we lock by using the mentioned method, it generated
another 2 files, atpvbaen.xls (ATPVBAEN.XLA) and funcres
(FUNCRES.XLA). Do you have any ideal of them?
Regards
-----Original Message-----
Hi Illuminator,
If the project has been named, say "MyProject",
VBAProject properties would
be: MyProject Properties.
---
Regards,
Norman
"Norman Jones" wrote
in message
...
Hi Illuminator,
In the VBE:
Tools | VBAProject Properties | Select Protection
tab
| Check Lock project for viewing | Furnish &
confirm password | OK
Whilst this will deny casual access to your code, the
protection afforded
by Excel may readily be removed by anyone with the
ability to Google.
---
Regards,
Norman
"illuminator"
wrote in message
news:6C119A30-C07E-4BD4-B24A-
...
How do I hide and protect an Excel module or macro
from other users
.