Protected Sheets & Unlocked Cells

F

flynn

If a range of cells are unlocked and the sheet is
protected, is there a way to allow users to bold or
underline the unlocked cells?
 
F

Frank Kabel

Hi
in the protection dialog (depending on your Excel version) check 'allow
cell formating).
 
F

flynn

Thanks Frank! I'm working in Excel 2000. I was unable to
find this option . . . safe to assume this can not be done
in this version?
 
D

Dave Peterson

You could provide the users with a couple of macros that unprotect the sheet, do
the formatting, and then reprotect the sheet.

Or (really ugly follows):

Provide a few exemplar cells formatted the way you want.

The user can select them, hit the format painter and the paste over the cell
they want.

(or just copy, then paste special|formats.)
 

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

How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksh 6
Edit/Fill/Series on Protected Sheet 1
Excel 2003 Regarding Cell Protection 1
How to prevent Cut&Paste to change style and data validation on protected sheet 1
How to change format protection default to unlocked? 2
Locked Several Worksheets, allow format cells/select unlocked cell 2
Protected sheet - attempt to delete row = unmerged cells 5
Locked cells are still able to be selected with proper protection 1

Top