Resizing Rows and Columns on a Protected Worksheet

[SSjmg2477]

Is there a way to protect a worksheet with a macro, but set some attribute so that the users would still be able to resize rows and columns?

 

[Smitty]

If you're in v.2003 you can set that (maybe in 2002 as well).

Prior to that though and you'd need to give them a mechanism to unprotect/size/reprotect.

Why not use AutoFit in your code?

HTH,

Smitty

 

[Oaktree]

In Excel 2002 or later, try:

ActiveSheet.Protect "your password here", AllowFormattingColumns:=True, AllowFormattingRows:=True

 

[SSjmg2477]

Thanks guys