I have a protected and shared workbook with data filters enabled. Often
users will exit the workbook and leave their data-filter choices ... making
it difficult for the next user.

I recorded a show-all macro that runs on a button but it gives a VB error
(something like) "that feature is not allowed on a protected workbook".

Any ideas how I can get around this limitation? Thanks.