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.

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.

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.

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.

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.

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.