Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When we use this code:
ActiveSheet.Protect (which works perfectly in every other respect), the user cannot change the text alignment nor the font style (bold, italic, etc.) without unprotecting the sheet. Yet rather than have a button or toolbar to do these things, as wondering if there was an easy line of code that would protect the sheet in every respect that ActiveSheet.Protect does but leaving those 2 things available? Is this do-able. Just curious. Thanks! :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to prevent Cut&Paste to change style and data validation on protected sheet | Excel Discussion (Misc queries) | |||
How to prevent Cut&Paste to change style and data validation on protected sheet | Excel Discussion (Misc queries) | |||
How to change font colour in unlocked cell of protected sheet | Excel Discussion (Misc queries) | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
change font when sheet is protected | Excel Discussion (Misc queries) |