ExcelBanter - fill color a protected cell without unprotecting worksheet

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - fill color a protected cell without unprotecting worksheet (https://www.excelbanter.com/excel-worksheet-functions/255003-fill-color-protected-cell-without-unprotecting-worksheet.html)

taibbico

fill color a protected cell without unprotecting worksheet

Don Guillett[_2_]

fill color a protected cell without unprotecting worksheet

The archives do not understand blank email bodies so use a meaningful
subject line and then state your question in the body of the post.
Unprotectcolorprotect

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"taibbico" wrote in message
...

Gord Dibben

fill color a protected cell without unprotecting worksheet

When you protect the sheet make sure you enable "Format Cells"

Gord Dibben MS Excel MVP

On Mon, 1 Feb 2010 08:08:01 -0800, taibbico
wrote:

All times are GMT +1. The time now is 12:00 AM.