T
Tempered Steel
Hi,
I am creating a Database template, the purpose of which is to seek the line
managers to input scores against every member in their respective teams.
There are only 4 fields viz. |1| Employee ID |2| Employee Name |3| Department
|4| Score.
I want to ensure the sanctity of the Cell Formats (Font Face, Font Size,
Colour etcetera, etcetera) as defined by me; however, I want the managers to
be able to enter the values into those cells.
If I protect the cells:
--> The managers cannot enter the values...
If I don't protect the cells:
---> When the managers copy paste the data-list from some other excel file
the data seem to retain the formatting of the other excel (unless they do a
paste special)
How do I ensure that that the managers have access to input data into the
cell, but not get to modify the cell format!!!
Please help...!
I am creating a Database template, the purpose of which is to seek the line
managers to input scores against every member in their respective teams.
There are only 4 fields viz. |1| Employee ID |2| Employee Name |3| Department
|4| Score.
I want to ensure the sanctity of the Cell Formats (Font Face, Font Size,
Colour etcetera, etcetera) as defined by me; however, I want the managers to
be able to enter the values into those cells.
If I protect the cells:
--> The managers cannot enter the values...
If I don't protect the cells:
---> When the managers copy paste the data-list from some other excel file
the data seem to retain the formatting of the other excel (unless they do a
paste special)
How do I ensure that that the managers have access to input data into the
cell, but not get to modify the cell format!!!
Please help...!