3mustgetbeer
01-28-2011, 11:59 AM
Hi guys!
I'm new here so go easy :beg:
I have pretty much completed a spreadsheet with macros and need to (un)protect it before & after running the macros.
I have this
ActiveSheet.Unprotect Password:="abc123"
Which works fine, however I want to an options into the protection - for example I don't want the user to be able to select any locked cells.
Do you guys know what line this will take? - or prefereably some sort of glossary for the different options for protection?
Thanks for any replies :beerchug:
3MGB
I'm new here so go easy :beg:
I have pretty much completed a spreadsheet with macros and need to (un)protect it before & after running the macros.
I have this
ActiveSheet.Unprotect Password:="abc123"
Which works fine, however I want to an options into the protection - for example I don't want the user to be able to select any locked cells.
Do you guys know what line this will take? - or prefereably some sort of glossary for the different options for protection?
Thanks for any replies :beerchug:
3MGB