I have a protected worksheet but still need users to be able to hide/unhide
columns to customise their views and prints - how can I do this? I found the
following code posted in this discussion board but this doesn't allow me to
hide/unhide even when I run it every time the workbook is opened.... Any
ideas?

Option Explicit
Sub RUN_ME_EVERY_TIME_YOU_OPEN()
With Worksheets("Report")
.Protect Password:="bsd", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub