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
Bookmarks