That is the plan if I cna't find an easier way. Thanks anyway.

"Gord Dibben" wrote:

Pam

Excel security is not too robust.

Protection passwords can be broken by a resourceful manager.

The rule is.....if you don't want snoops to see sensitive information, don't
include it in the file.

Devise some other method of receiving the forecasts and you enter them into
the sensitive workbook.


Gord Dibben Excel MVP


On Thu, 15 Dec 2005 16:57:55 -0000, <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.