I am having filter issues in a shared workbook. I am thinking that I can
solve this by having a code like this:

ActiveSheet.ShowAllData

inserted so that when each person opens the shared workbook it will clear
current filters for that user.

can i use this code in a shared workbook with multiple people in it and
filtering at the same time? If so, where do i put this code? i am only
familar with creating control buttons and are not familar with where to put
code on open for excel?

Thanks