Range.Autofilter not working on protected sheet

[brokenbiscuits]

Hi

I have a protected sheet that has an autofilter applied to it on range A2:G5000. 'Use Autofilter' is selected in the Protect Sheet dialog box, and I can manually use the autofilters without a problem.

However, in my code I was having some issues with the Freeze Panes aspect, so I recorded myself removing freeze panes and adding it again, and with a bit of tinkering came up with the following:

Please Login or Register  to view this content.

This works fine when the sheet is not protected, but even though I can manually do this process fine with a protected sheet, I get a runtime 1004 error at the first line above advising me 'You cannot use this command on a protected sheet'. I can't just unprotect the sheet as this will be a shared spreadsheet.

Any ideas why this might be happening?

[Blokeman]

Try;

Please Login or Register  to view this content.

[brokenbiscuits]

Thanks for the response Blokeman - however I can't unprotect the sheet as this will be a 'Shared' workbook.

When I perform the steps manually I don't need to unprotect the sheet anyway, that's what confuses me. I can't understand why I can perform an operation on the sheet manually but I can't do exactly the same thing with VBA. I can record myself doing it (and it works fine) then as soon as I step through the recorded macro I get the same error.

[brokenbiscuits]

Hate to bump, but this is still killing me so I thought I'd give it one more shot - any ideas anyone?