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 colum...
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!).
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
