27th February 2006, 11:50 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
|
Originally Posted by dingoboy
Hi Again La Mer, Sorry I cant seem to lock the "columns"
If i try it it says i must protect the sheet first, when i do that i cant just select the columns, running me arround in circles. any thoughts.
I have 12 cloumns, i want to protect all except column E and F, ie win/loss input and div paid Thanks Dingo
|
Make sure you tick the Lock box first, then when you goto Tools/Prtoection/ProtectSheet make sure you only have the Select Unlocked Cells box ticked with all the others being left unticked in the Protect Sheet box, then issue a password & everyhting should be Ok. |