excel sheet protection

M

mark

Is there a way for me to change font properties (bold,
color) with sheet protection on and cells unlocked?

I need to keep protection for the worksheet's contents.
I can change the data for the unlocked cells but I cannot
alter the data's properties.
 
E

Earl Kiosterud

Mark,

In XLXP, you can specify that users can change formatting of unlocked cells
in the Tools - Protection command. Not available in 97. Don't know about
2000.
 

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

Protecting Word 2019 document 0
hide columns on a protected sheet 2
I can still select & manipulate locked & protected cells in '07 1
Tab Key 1
Protecting Cells In A Worksheet 1
Formatting of cells in a locked worksheet. EG shading 1
Lock Unlock Cell Protection 3
Override protected sheet message? 4

Top