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:
Sheet1.Unprotect ("bcmd") Sheet1.Protect ("bcmd")




Reply With Quote