ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Password concern (https://www.excelbanter.com/excel-programming/437061-password-concern.html)

Victoria

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



All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com