Cell Protection

  • Thread starter Thread starter andyp
  • Start date Start date
A

andyp

Hi
When protecting a selection of cells in a workbook
(Format cells -locked) then password protect worksheet,
the cells that are not locked allow text input,
but if i try to shade(colour) the cells it will not
allow me to.
Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting of cells in a locked worksheet. EG shading 1
Change cell color in protected sheet 1
Why is AutoSum iinoperable w/protection when column is unlocked? 2
Protected Sheets 2
Cell Protection 1
Deleting Rows Containing Protected Cells 2
Use of CELL("protect") in conditional formatting in Excel 07 3
Comparison of columns using Conditional Formatting 3

Back
Top