| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow font colour changes in protected
Activesheet.Unprotect
ci = Application.Dialogs(xlDialogPatterns).Show Activesheet.Protect -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gizmo63" wrote in message ... 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 | |||
| 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) | |||
| Allow font colour changes in protected | Excel Programming | |||
| 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
