View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Afsha Afsha is offline
external usenet poster
 
Posts: 22
Default Protection password iin VBA, how to avoid user seeing it?

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