| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow font colour changes in protected
If you are using xl2002 or later, when you protect the sheet, click the box
to allow format cells I would think (worked for me). In earlier versions, there is no such setting. -- Regards, Tom Ogilvy "Gizmo63" wrote: Hi all, Is there a cunning line of VBA code that will modify protection settings so users can change the font colour in unlocked cells within a protected spreadsheet? Cheers Giz |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Allow font colour changes in protected
Cheers Tom but I'm looking for something a little more specific.
The only format change I want the user to be able to do is font colour. I still want borders and background colours locked. "Tom Ogilvy" wrote: If you are using xl2002 or later, when you protect the sheet, click the box to allow format cells I would think (worked for me). In earlier versions, there is no such setting. -- Regards, Tom Ogilvy "Gizmo63" wrote: Hi all, Is there a cunning line of VBA code that will modify protection settings so users can change the font colour in unlocked cells within a protected spreadsheet? Cheers Giz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| different colour font in same cel | Excel Worksheet Functions | |||
| textBox font colour the same as cell font colour???????? | Excel Discussion (Misc queries) | |||
| How to change font colour in unlocked cell of protected sheet | Excel Discussion (Misc queries) | |||
| Using Font Colour | Excel Programming | |||
| can the fill colour of a bar be tied to the data font colour data | Charts and Charting in Excel | |||
Linear Mode
