Mike

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK

Now ToolsProtectionProtect Sheet. This is mandatory.

You can set a password to unprotect the sheet. These can easily be broken in
Excel but will keep your formulas from being accidentally overwritten.

NOTE the options available in xl2002 and 2003 when you hit Protect Sheet


Gord Dibben Excel MVP

On Wed, 07 Feb 2007 21:02:31 -0500, M wrote:


Using an excel program at work that works perfectly. However it has
been recently discovered there are certain end users who have been
modifying certain formulas and variables (company commissions
schedule, etc.) that have been stored in certain cells. These cells
are located in A47:DA96. I have set the Row Height (47 to 96) to
zero, however it is still accessible by others. How can I protect
these cells either by setting some password so no one can change the
info in these cells or hide them from view completely?

Thank you in advance.

Mike

Using an excel program at work that works perfectly. However it has
been recently discovered there are certain end users who have been
modifying certain formulas and variables (company commissions
schedule, etc.) that have been stored in certain cells. These cells
are located in A47:DA96. I have set the Row Height (47 to 96) to
zero, however it is still accessible by others. How can I protect
these cells either by setting some password so no one can change the
info in these cells or hide them from view completely?

Thank you in advance.

Mike

On Wed, 07 Feb 2007 15:52:37 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

I tried the instruction below however it protects the whole worksheet.
The end user in my program needs to enter certain variables, eg.
quantities and symbols in cells B4:B10.

How can I protect the whole worksheet except for these cells.

Thank you

Mike


Mike

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK

Now ToolsProtectionProtect Sheet. This is mandatory.

You can set a password to unprotect the sheet. These can easily be broken in
Excel but will keep your formulas from being accidentally overwritten.

NOTE the options available in xl2002 and 2003 when you hit Protect Sheet


Gord Dibben Excel MVP

On Wed, 07 Feb 2007 21:02:31 -0500, M wrote:


Using an excel program at work that works perfectly. However it has
been recently discovered there are certain end users who have been
modifying certain formulas and variables (company commissions
schedule, etc.) that have been stored in certain cells. These cells
are located in A47:DA96. I have set the Row Height (47 to 96) to
zero, however it is still accessible by others. How can I protect
these cells either by setting some password so no one can change the
info in these cells or hide them from view completely?

Thank you in advance.

Mike

On 2ÔÂ8ÈÕ, ÉÏÎç11ʱ18·Ö, M wrote:
On Wed, 07 Feb 2007 15:52:37 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

I tried the instruction below however it protects the whole worksheet.
The end user in my program needs to enter certain variables, eg.
quantities and symbols in cells B4:B10.

How can I protect the whole worksheet except for these cells.

Thank you

Mike

Mike

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK

Now ToolsProtectionProtect Sheet. This is mandatory.

You can set a password to unprotect the sheet. These can easily be broken in
Excel but will keep your formulas from being accidentally overwritten.

NOTE the options available in xl2002 and 2003 when you hit Protect Sheet

Gord Dibben Excel MVP

On Wed, 07 Feb 2007 21:02:31 -0500, M wrote:

Using an excel program at work that works perfectly. However it has
been recently discovered there are certain end users who have been
modifying certain formulas and variables (company commissions
schedule, etc.) that have been stored in certain cells. These cells
are located in A47:DA96. I have set the Row Height (47 to 96) to
zero, however it is still accessible by others. How can I protect
these cells either by setting some password so no one can change the
info in these cells or hide them from view completely?

Thank you in advance.

Mike

@ Mike.
Gord Dibben have told you in detail how to protect the cells you want
and unprotect the other cells.
the solution is the cell's locked property. when the worksheet is
protected, you 're not allowed to edit the locked cells,but allowed
to edit the unlocked cells. so Gord suggest as follows:
'---------------------------------------------------------------------------------
By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck
"locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check
"locked"
and OK

Now ToolsProtectionProtect Sheet. (note that, this need not
password ,and you could unproect it without password.)
'---------------------------------------------------------------------------------
So if you want to protect the whole worksheet except some cells such
as range(" B4:B10") ,you could change cells in range(" B4:B10") to
be unlocked. the others in the sheet stay locked, and at last please
protect the sheet.

On 2ÔÂ8ÈÕ, ÏÂÎç4ʱ01·Ö, wrote:
On 2ÔÂ8ÈÕ, ÉÏÎç11ʱ18·Ö, M wrote:



On Wed, 07 Feb 2007 15:52:37 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

I tried the instruction below however it protects the whole worksheet.
The end user in my program needs to enter certain variables, eg.
quantities and symbols in cells B4:B10.

How can I protect the whole worksheet except for these cells.

Thank you

Mike

Mike

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK

Now ToolsProtectionProtect Sheet. This is mandatory.

You can set a password to unprotect the sheet. These can easily be broken in
Excel but will keep your formulas from being accidentally overwritten.

NOTE the options available in xl2002 and 2003 when you hit Protect Sheet

Gord Dibben Excel MVP

On Wed, 07 Feb 2007 21:02:31 -0500, M wrote:

Using an excel program at work that works perfectly. However it has
been recently discovered there are certain end users who have been
modifying certain formulas and variables (company commissions
schedule, etc.) that have been stored in certain cells. These cells
are located in A47:DA96. I have set the Row Height (47 to 96) to
zero, however it is still accessible by others. How can I protect
these cells either by setting some password so no one can change the
info in these cells or hide them from view completely?

Thank you in advance.

Mike

@ Mike.
Gord Dibben have told you in detail how to protect the cells you want
and unprotect the other cells.
the solution is the cell's locked property. when the worksheet is
protected, you 're not allowed to edit the locked cells,but allowed
to edit the unlocked cells. so Gord suggest as follows:
'---------------------------------------------------------------------------------
By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck
"locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check
"locked"
and OK

Now ToolsProtectionProtect Sheet. (note that, this need not
password ,and you could unproect it without password.)
'---------------------------------------------------------------------------------
So if you want to protect the whole worksheet except some cells such
as range(" B4:B10") ,you could change cells in range(" B4:B10") to
be unlocked. the others in the sheet stay locked, and at last please
protect the sheet.

And I want to ask a question about protection. my question is as
follows:
there are two categories of cells in some worksheet: locked cells and
unlocked cells.
when the worksheet above is protected, the user could not only change
value of the unlocked cells,but could also change their format. and he
could do nothing to the locked cells, except choosing them.
The above description is what I want to reach, but to my depress, when
the worksheet is protected. I couldn't format the unlocked cells.if
the format cells checkbox is not selected in "Protect Sheet" dialog
box. and in opposition to it, if the format cells checkbox is selected
in "Protect Sheet" dialog box,the locked cells could also be formated.