| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
change font when sheet is protected
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 !!!! |
|
#2
|
|||
|
|||
|
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 On Mon, 7 Feb 2005 10:49:06 -0800, "vivisss" wrote: 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 !!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
| Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
| how to hide rows in a protected sheet | Excel Worksheet Functions | |||
| How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
| How do I change the font color of my sheet tabs? | Excel Discussion (Misc queries) | |||
Hybrid Mode
