Hiding Columns in protected sheet

[larsson7]

Hi,

I have written a macro to hide columns on a worksheet and it works well..... except when the worksheet is protected with a password.

Is there any code I can add to my existing macro to get around this problem?

 

[Paul B]

try something like, Sheets("Sheet1").Unprotect password:="123"

 

[Shado]

Be sure to protect the sheet when you are done, same as above except replace Unprotect with Protect.
This message was edited by Shado on 2002-10-13 16:53