Hide/Unhide columns in an protected sheet

[curti]

Hello together

I want to write a macro which can hide/unhide Columns in a protected sheet.

Can someone help me?
thanks and regards from Switzerland

 

[earlyd]

Hi Curti,

Have your macro unprotect the sheet in the beginning and reprotect it in the end. Put your hide/unhide code in between. You can get the code by recording yourself unprotecting and reprotecting.

 

[curti]

When I let run the marcro which should unhide the column,
I have to enter the password. This I want to avoid.

curti

 

[Wookie]

Here is some code i use to do something similar. My password being word

Sheets("A").Select
ActiveSheet.Unprotect "word"
Cells.Select
Selection.EntireColumn.Hidden = False
Columns("N:Q").Select
Selection.EntireColumn.Hidden = True
Columns("AG:AT").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
ActiveSheet.Protect Password:="word"

 

[earlyd]

Do you need a password? You can protect the sheet without one if the purpose of protection is to avoid accidentally overlaying something.

If you need one, then see last post.