| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected sheet question -- way to allow user to change text alignment and font style?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected sheet question -- way to allow user to change text align
That depends on your version of XL if you have 2002 or better then you can
try this... activesheet.Protect AllowFormattingCells:=True -- HTH... Jim Thomlinson "StargateFanFromWork" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected sheet question -- way to allow user to change text align
"Jim Thomlinson" wrote in message
... That depends on your version of XL if you have 2002 or better then you can try this... activesheet.Protect AllowFormattingCells:=True -- HTH... Oops, sorry. I keep forgetting to say version. I have XL2K ... Will the above work with this version?? Thanks! Jim Thomlinson "StargateFanFromWork" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected sheet question -- way to allow user to change text align
"StargateFanFromWork" wrote in message
... "Jim Thomlinson" wrote in message ... That depends on your version of XL if you have 2002 or better then you can try this... activesheet.Protect AllowFormattingCells:=True -- HTH... Oops, sorry. I keep forgetting to say version. I have XL2K ... Will the above work with this version?? I tried this out and it naturally doesn't work in XL2K. Is there an alternative for those of us with older XL versions? Thanks! :oD Thanks! Jim Thomlinson "StargateFanFromWork" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected sheet question -- way to allow user to change text align
"Jim Thomlinson" wrote in message
... That depends on your version of XL if you have 2002 or better then you can try this... activesheet.Protect AllowFormattingCells:=True -- HTH... Jim Thomlinson Does no answer mean there's nothing we can do in XL2K? <g Thanks. :oD "StargateFanFromWork" wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected sheet question -- way to allow user to change text align
You could write your own macros that allow only the formatting that you want to
support. unprotect the sheet do the formatting you want protect the sheet StargateFanFromWork wrote: "Jim Thomlinson" wrote in message ... That depends on your version of XL if you have 2002 or better then you can try this... activesheet.Protect AllowFormattingCells:=True -- HTH... Jim Thomlinson Does no answer mean there's nothing we can do in XL2K? <g Thanks. :oD "StargateFanFromWork" wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
![StargateFanFromWork[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
