ExcelBanter - Protecting sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protecting sheets (https://www.excelbanter.com/excel-discussion-misc-queries/785-protecting-sheets.html)

Protecting sheets

Can I protect a sheet from format changes, but still be able to change cell
color? I am using Excel 2000.

Gord Dibben

TV

Cell color is a format.

Conditional formatting will work on any cells you have set to be "unlocked"
even when the sheet is protected.

Otherwise you would need to use VBA to unprotect the sheet, make the color
change then re-protect.

Do you want to go this route?

Gord Dibben Excel MVP

On Mon, 29 Nov 2004 12:39:04 -0800, "TV" wrote:

Can I protect a sheet from format changes, but still be able to change cell
color? I am using Excel 2000.

All times are GMT +1. The time now is 02:25 PM.