View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Victoria Victoria is offline
external usenet poster
 
Posts: 35
Default Password concern

I have code on my Sheet that allows the user to Add or Delete rows. Since
parts of my Sheet are protected, so I use something like...

ActiveSheet.Unprotect Password:="xyz"
do Adding or Deleting Row stuff here...
ActiveSheet.Protect Password:="xyz"

This actually works fine. Anyone who hits Alt F11, though, can see the
password. Is there an easy way to avoid this without getting into a lot of
high-level security that, I'm sure, would be beyond me!

Thanks
Victoria