N
nigsy
Hi,
I have a worksheet setup for employees to enter progress statistics, sorted
by "course name"
The first 5 columns rely on user input, but the last 3 columns I have locked
as they are populated by formulae and I was fed up with them being
overwrtitten.
The problem we now have is that when adding a new row of data the user can
not sort the data alphebetically by course name as they get the message
"cells locked, got to unprotect etc.
Is there anyway to still allow them to apply the sort as required and still
keep the last 3 columns protected.
I have a worksheet setup for employees to enter progress statistics, sorted
by "course name"
The first 5 columns rely on user input, but the last 3 columns I have locked
as they are populated by formulae and I was fed up with them being
overwrtitten.
The problem we now have is that when adding a new row of data the user can
not sort the data alphebetically by course name as they get the message
"cells locked, got to unprotect etc.
Is there anyway to still allow them to apply the sort as required and still
keep the last 3 columns protected.