Macro wont work when sheet is protected

When I use the macro with the sheet protected I get run-time error '1004': "you cannot use this command on a protected sheet"

Please Login or Register  to view this content.

Is there a workaround for this or do I have to apply the filter the old-fashioned way? I would like to be able to simply press a button linked to the macro, even when the sheet is protected.

Hi, Willardio,

there are two ways you may handle this problem. First is unprotect the sheet before action and protect thereafter, the second is to protect the sheet via VBA in your Workbook_Open and use the parameter UserInterfaceOnly:=True which will enable macros to change data but normal usage still is prohibited.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Your macro should then work on Sheet Test.

Ciao,
Holger