Format Unlocked Cell on Protected sheet

[Biggsmiles]

I am using excel 2003. I have locked and unlocked cell on the same sheet.

I have protected the sheet. I can enter data into the unlocked cells. But I can't

BOLD the text in the unlocked cells.

Is there anyway to allow the user to bold the text in the unlocked cells in a protected sheet?

Thanks,

BiggSmiles

 

[bfarley4]

I'm pretty sure starting in 2003 when you protect the sheets that you have the multiple options to check - look for the one that says something like "Format cells" and make sure it is checked. If this isn't an option then you can try this code to protect sheets

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, _ Scenarios:=True , AllowFormattingCells:=True

Hope this helps,
Ben