Protected filter range error

[Throughstream]

Hi I have the following vba code:

Please Login or Register  to view this content.

I want to protect the sheet so I've un-ticked locked on the filter cell. I've also enabled allow "sort" and use autofilter in the protect settings but it keeps flagging this code as an error. It works fine If I don't protect the sheet.

Cheers

Dave

[BellyGas]

When you protect the sheet use the switch: userinterfaceonly = True

eg

Please Login or Register  to view this content.

This tells VBA to allow code to make changes to cells but prevent users from doing so.

NB: Excel will 'forget' that you've used this switch every time you open the workbook, therefore, you're going to need to add some code to the workbook_open event to remind it. To do this, simply unprotect and re-protect every sheet you need to be able to allow VBA to make changes when protected.

Please Login or Register  to view this content.

[Throughstream]

Many thanks for that

[Throughstream]

Hi I'm having an issue where I put the password into unprotect the sheet but it's not being recognized.