Pam

I don't recommend this method...see my other post........but you can unlock
specific cells for the managers to enter forecasts before you protect the
sheet.

pick some cells for them to access then FormatCellsProtection and uncheck
"locked"

Now ToolsProtectionProtect Sheet.


Gord Dibben Excel MVP


On Thu, 15 Dec 2005 12:02:02 -0800, "Pam P"
wrote:

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.