G
Guest
Using Excel 2003. I created a Reset Macro to reset all AutoFilters to “Allâ€
in a list. The macro looks like:
Sub Reset()
Range("A6").Select
Selection.AutoFilter Field:=1
Range("B6").Select
Selection.AutoFilter Field:=2
End Sub
The above works fine until I password-protect the worksheet, and then I get
a “Run Time Error 1004 , cannot use this command on a protected t sheetâ€.
Even though I allow users to Sort & Use Autofilter. Any suggestions? Thanks
in advance for your help.
in a list. The macro looks like:
Sub Reset()
Range("A6").Select
Selection.AutoFilter Field:=1
Range("B6").Select
Selection.AutoFilter Field:=2
End Sub
The above works fine until I password-protect the worksheet, and then I get
a “Run Time Error 1004 , cannot use this command on a protected t sheetâ€.
Even though I allow users to Sort & Use Autofilter. Any suggestions? Thanks
in advance for your help.