Sheet Protection On

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JMay - 31 Aug 2007 16:04 GMT

It seems that if a sheet has been "protected" I can not
format (fill with color) even a cell that is not protected.

What is the solution for this?

I need to be able to format unprotected cells, rows and also columns. But How?

TIA,

Reply to this Message

Bob Greenblatt - 31 Aug 2007 16:21 GMT

On 8/31/07 11:04 AM, in article 16WBi.232193$g86.6996@newsfe14.lga, "JMay"
<jmay@cox.net> wrote:

> It seems that if a sheet has been "protected" I can not
> format (fill with color) even a cell that is not protected.
>
> What is the solution for this?

There is none. That's what protection is for.

> I need to be able to format unprotected cells, rows and also columns. But
> How?

There are just some things you can't do with the sheet protected, even if a
cell happens to be unprotected. To change cell colors you must first
unprotect the sheet. You can only change unprotected cell values when a
sheet is protected.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

JE McGimpsey - 31 Aug 2007 18:16 GMT

> It seems that if a sheet has been "protected" I can not
> format (fill with color) even a cell that is not protected.
[quoted text clipped - 3 lines]
> I need to be able to format unprotected cells, rows and also columns. But
> How?

The only way I know of to do this is to use VBA event macros to replace
sheet protection. Doing so can be either very simple or very
complicated, depending on what properties you want to protect, and may
require running OnTime macros to audit the sheet for changes.

Reply to this Message

Mac Forum / Applications / Excel / August 2007

Sheet Protection On