Protection password iin VBA, how to avoid user seeing it?
Alt-F11
look at tools - VBAproject properties and check the lock project for viewing
box and then set a password.
Just a note of caution. Excel security isn't very robust.
"Afsha" wrote:
I recently posted a question on how to be able to group and outline data in a
protected worksheeet. Dave Peterson gave me advise on the code need to be
entered into VBA to enable this. Which is now working.
I just want to ensure how can I now avoid a user of my protected worksheet
to not be able to hit alt-f11 and be able to se the password in the code? I
protected the workbook, however was still able to hit alt-f11 and see the
code which has the password.
thanks
Afsha
|