But If I protect the wole worksheet, they will not be able to enter their
forcasts into the non-hidden fields.

"Andy" wrote:

Hi

You could hide the rows and then protect the sheet. However, if a user types
a hidden cell into the address box, the information will display in the
formula bar. To avoid this, you'll have to format the row as Hidden
(Format/Cells/Protection) and then hide the row and then protect the sheet.

Andy.

"Pam P" <Pam wrote in message
...
I want to send out a forcast document to various managers so that they can
enter their forcast and send it back to me. However I need to hide the
rates
row and the totals column and ensure they can not unhide the column.