i have problem when try to advanced filter data in another sheet that is protected
I am using the macro in sheet that also protected too
i try to use:
Sheets("Report").Unprotect ""
Sheets("Database").Unprotect ""
'Advanced Filter Code
Sheets("Database").protect ""
Sheets("Report").protect ""
it say runtime error 1004 "you can not use this command i protected sheet"
thank you
I am using the macro in sheet that also protected too
i try to use:
Sheets("Report").Unprotect ""
Sheets("Database").Unprotect ""
'Advanced Filter Code
Sheets("Database").protect ""
Sheets("Report").protect ""
it say runtime error 1004 "you can not use this command i protected sheet"
thank you