hi everyone, i want to create a password protected shared workbook with filter options enabled. when i am password protecting the sheet and sharing it and then trying to use auto filter option using vba macro, it shows error. it's asking to unprotect the sheet first which means to remove sharing then unprotect and then use filter option and again share it. but if these steps are followed the previous users will no longer be able to use the sheet as the sheet is changed from sharing mode. however i am able to use the auto filter option manually. not sure, why the code is not doing it. if anyone can help as to how to use the auto filter option on a password protected and shared workbook without changing the sharing mode so that the other users can stay connected to the sheet. thank you!!!