Forum Discussion
Solved
unlock column
Very simply, I want to have a single column unlocked while the rest of the sheet is locked. I want my customer to enter enter a quantity so that he can see the total calculated price. All other columns need to be protected as they show the description and the unit price. Make it simple for me!
rolf130 Select the cells your customer should be able to edit. Right click inside the range of selected cells. Press "Format cells" and then Protection. Uncheck the "locked" checkbox. OK
Now, on the Review ribbon, Protect the workbook with a password (and remember it!).
2 Replies
rolf130 Select the cells your customer should be able to edit. Right click inside the range of selected cells. Press "Format cells" and then Protection. Uncheck the "locked" checkbox. OK
Now, on the Review ribbon, Protect the workbook with a password (and remember it!).
it worked...........thank you! Riny_van_Eekelen
