change font when sheet is protected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am working on a spreadsheet with a lot of formulas in it. I am then
protecting it and only leaving the comments parts unprotected. My question is
once I've protected the sheet, I cannot change the font size or bold,
undeline or italics the words in the comment section. I want the comments
column to be unprotected so that anyone can write and change font or color if
need to be. Please help !!!!
 
Depends upon which version of Excel you are using.

With 2002 and 2003 you can, when protecting the sheet, checkmark "edit
objects" which will allow changing fonts and styles in a Comment.


Gord Dibben Excel MVP
 
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

Protected sheets in a excell spreedsheet 1
Change font colours while protected 3
setting the font type for all comments on excel spreadsheets 3
Changing font color of protected cells programatically 6
Can I protect data in a cell, but allow comments to be entered. 6
Protection Gets Removed!! 2
comments in protected sheet 2
Protection on Worksheets 5

Back
Top