How to use advanced filter function in a protective mode

Hi guys,

I have actually posted the same thread (enquiry) few weeks back but wasn't resolved until now and seems like no one's looking at the thread any more.

So, I am putting the thread here again. And If this is againt the forum regulation, please let me know then I will put this thread down.

Below is the code I have used on my worksheet to enable advanced filter button in a protective worksheet mode but I get an error.

Can anyone help please?

Cheers,

Please Login or Register  to view this content.

Hi TMShucks,

I still get the same error message from excel as below:

Run-time error ‘1004’:
You cannot use this command on a protected sheet. To use this command, you must first unprotect the sheet (Review tab, Changes group, Unprotect Sheet button). You may be prompted for a password.

I am using a button to activate the code (code is assigned to the button). Any idea why?

Hi TMShucks,

Please see the attached sample excle file below. hope this will help you understanding the issue I am facing at the moment. Thanks.

Hi TMShucks,

I've had a look at your excel file attached above and seems like none of the buttons in the workbook is working.

can you please check if that's the one you meant to upload?

Many thanks.

Yes it does work. Sorry and Thank you for your help TMShucks Appreciated!!!!