Password concern

V

Victoria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spell Checking on a protected sheet 3
Macros and Password Protection 6
Password Oddity 0
Spell Check Protect Reprotect with same settings 1
Format columns & cells in a protected sheet - VBA code 2
Format columns and cells in a protected sheet 2
Q for Ivyleaf 0
ProtectSheet Options are un-checking after macro 11

Top