VBA Code to Allow Formatting Columns

[charpentiert]

I have the following code and I want to also allow formatting of columns. I have tried adding
.AllowFormattingColumns = True

but this does not work.



Private Sub Workbook_Open()
With Worksheets("Forecast")
.Protect Password:="test", Userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

 

[JackDanIce]

Does this link help?
http://www.ozgrid.com/forum/showthread.php?t=152730&page=1

 

[VoG]

Try

.Protect Password:="test", Userinterfaceonly:=True, AllowFormattingColumns:=True

 

[charpentiert]

Thanks the statement below worked great -

.Protect Password:="test", Userinterfaceonly:=True, AllowFormattingColumns:=True

 

[molly13]

Worked perfectly. Thanks so much!!