Protecting sheet with auto filter

[geng]

Hi! I have a workbook with an autofilter macro code on it. But whenever I protect it, the code would not work.

Is there a way to protect a cell at the same time use the auto filter macro?

Thanks!

[JBeaucaire]

Either when the workbook opens or when the macro runs, reapply the "protection" adding the UserInterfaceOnly flag. Once that is turned on, the sheet is protected from humans, but VBA is free to function on it as if it were not protected. Very convenient.

Please Login or Register  to view this content.

[teylyn]

Hello,

in your code, you can unprotect the worksheet, run the filter code and then re-protect the worksheet.

Please Login or Register  to view this content.

[geng]

This is my autofilter code.

How do i apply the code that you gave on this code?

Please Login or Register  to view this content.

Thanks!

[geng]

Hello,

in your code, you can unprotect the worksheet, run the filter code and then re-protect the worksheet.

Please Login or Register  to view this content.

Thanks teylyn!