hi guys!!! i have a question, how can i locked the sheet with only 'select unlocked cells' enabled. at present i only have this code which locked and unlocked sheet but with 'select locked cells' and 'select unlocked cells' enabled..but i only want 'select unlocked cells' enabled. thanks in advance!!!
VB Code:
  1. Sheet1.Unprotect ("bcmd")
  2. Sheet1.Protect ("bcmd")