View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jean Cloutier
 
Posts: n/a
Default Allow user to run a macro in protected mode

I want to let other users of my spreadsheet to run a macro in protected mode.

The macro runs the filter for a big spreadsheet and I want to keep the
protection on but let users run the simple macro that hides the blank lines
with auto-filters.

Users get Run-time error 1004 when they click on my macro icon