Protected sheet question -- way to allow user to change text alignment and font style?

[StargateFanFromWork]

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! D

 

[Guest]

That depends on your version of XL if you have 2002 or better then you can
try this...

activesheet.Protect AllowFormattingCells:=True

 

[StargateFanFromWork]

That depends on your version of XL if you have 2002 or better then you can
try this...

activesheet.Protect AllowFormattingCells:=True

Oops, sorry. I keep forgetting to say version. I have XL2K ... Will the
above work with this version??

Thanks!

 

[StargateFanFromWork]

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! D

 

[StargateFanFromWork]

That depends on your version of XL if you have 2002 or better then you can
try this...

activesheet.Protect AllowFormattingCells:=True

Does no answer mean there's nothing we can do in XL2K? <g>

Thanks. D

 

[Dave Peterson]

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