Can someone tell me how to write a macro that will:

1) automatically run when I open a specific workbook
2) set AutoFilter to "Show All" on the "Summary" worksheet

While this may sound easy at first, please note that the aforementioned
workbook is Shared (Tools | Share Workbook...) and the worksheet ("Summary")
is protected. As a result, the "Show All" option within AutoFilter is
disabled due to the worksheet being protected. And because the workbook is
shared, you can't unprotect the workbook!

Any help would be greatly appreciated.
Thanks,
Bob