View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PA PA is offline
external usenet poster
 
Posts: 101
Default Macro in a protected worksheet

One of our users has recorded two simple macros, one to apply a custom filter
and one to remove the filter. It is required that the worksheet cells with
formulas be protected, and they are scattered over a broad range.
When protected, the macros will not run. Security is set to medium, and
both of the Trusted Sources check boxes are check.

Is there a workaround for this behaviour?

Thanks for any suggestions
Paul