Just be aware that Excel's protection is not invincible. There are commercial
password breakers as well as free methods (ie hex editor) available to break
VBA project passwords. A persistent individual with access to the internet
could view your code if they really wanted to.
HTH
Jason
Atlanta, GA
" wrote:
How can I keep a user from accessing macros in a spreadsheet. I have
some of the macros run when needed via VBA, and I have other macros
that I use for such things as protecting or unprotecting all or
selected sheets as needed. But I don't want the other users to be
able to manually access the macros.
Thanks for any help.
|