Formatting of cells in a locked worksheet. EG shading

  • Thread starter Thread starter Tommy
  • Start date Start date
T

Tommy

I have constructed a worksheet that is protected and has unlocked cells for
users to wnter information.

I need these users to be able to shade these unlocked cells or alter the
font colour however these functions are locked.

Any ideas?
 
Hi,

Unprotect the workbook and then reprotect it as follows: Tools, Protection,
Protect Sheet, and turn on Format Cells.
 

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

Why is AutoSum iinoperable w/protection when column is unlocked? 2
Comparison of columns using Conditional Formatting 3
I can still select & manipulate locked & protected cells in '07 1
protect worksheet but allow row deletion 3
Allow "List" to work in a locked sheet 4
lock only one cell 4
How to know if a worksheet was unlocked 8
Windows 7 Autofit row heights of merged cells in protected worksheet 0

Back
Top