Printable View
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:
VB Code:
Thanks a bunch!!! DKenny!
wait..i still have a problem...i've already try your code and it works but when I save my excel document and close it and open it again the cells that are locked is can be selected again..why is that so? I dont want locked cells to be selected. thanks in advance!
Just put DKenny's code in the "ThisWorkbook" module in an open event:
VB Code:
is there any other solution aside from putting it from?VB Code: