Sheet Protection Interference

I've got a small macro that's giving me problems, and I don't understand why. Sheets WS and WS2 are both protected, and on the settings for the protection I've checked "Allow Autofilter". On sheet WS2 the user selects a value in a data validation cell (E1). Then my macro takes that value to apply to the autofilter in WS. However, I'm getting a Run-Time error 1004 saying I can't run this command on a protected sheet (line beginning "ws.Range("N:N")...). Any help on this would be immensely appreciated.

Please Login or Register  to view this content.

Unprotect the sheet, do your stuff, and then reprotect the sheet.

You can also protect the sheet with UserInterfaceOnly:=True, but that works for some things and not others.