View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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