Protecting workbooks but allow use of colour pallet

[thompsy121]

Hi All,

i am currently working with protected workbooks but i need to allow the use of autofilters and the colour pallet to allow colour changes/fill colour.

Currently i am using the following code to allow the autofilter:

Private Sub Workbook_Open()
With Sheets("Sheet Name")
.EnableAutoFilter = True
.Protect "password", userinterfaceonly:=True
End With

I was wondering if i could use something similar to allow the colour pallet e.g.

.EnableCoulorPalet = True
.Enable?????????? = True

Advice on this would be appreciated.

Thanks