worksheet protection

[Colleen45]

This should be relatively simple to solve.
On my worksheet i am using advanced filters to view the data in the sheet.
But when I protect the sheet they do not work, I have unlocked those particular cells (Row 1). But it still does not allow the use of the advanced filter when the sheet protection is on. Any ideas?

 

[Colleen45]

Thankyou for your reply.
Sadly it did not work, what happens is this, after protecting the sheet i then make changes to column 18( which is one of the columns using the vba code. It also asks for the password to unprotect the sheet, (which obviously is not the desired result). So when i select cancel to unprotect the sheet, it gives me a "1004" error "application defined or object defined error"
then when i go to debug it points to this line

Target.Parent.Protect Userinterfaceonly:=True, AllowFiltering:=True

the second time i tried this it gave the same error but this time in debug pointed to this line

Target.Offset(0, 2).Value = Date

I'm convinced that it's something small thats being over looked

Thank you for any help you may be able to provide