View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StargateFanFromWork[_3_] StargateFanFromWork[_3_] is offline
external usenet poster
 
Posts: 77
Default 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