Hi:

I have created a macro that works for me when unprotected. However, when I
re-protect it before sending to mass users, it will not allow the custom
filter part of the macro to occur and returns an error. I have tried checking
the box in 'Protection'- 'Protect Sheet' that allows auto filter but there
does not seem to be an option for custom filter. Is there a way around this
without un-protecting the sheet? thank you!