hi
you did say how many sheets or what columns to hide but here is the syntax...

Private Sub Workbook_Open()
Sheets("sheet1").Columns("C:C").EntireColumn.Hidde n = True
Sheets("sheet2").Columns("C:C").EntireColumn.Hidde n = True
End Sub

adjust to suit your data.
personally i would use the before save event and hidde on close instead of
open
might be just me.

Regards
FSt1
"notso" wrote:

I want to automatically hide columns when the user opens a password protected
sheet or workbook. The users with the passwords sometimes leave the hidden
columns in unhidden when they save and close. How do I make sure that hidden
columns etc. are automatically hidden on all sheets when the workbook is
opened.