View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NStarch NStarch is offline
external usenet poster
 
Posts: 1
Default Macro to password protect and allow autofilter

I am looking for a macro to set up a protection that only allows someone to
use the AutoFilter. The protection needs to set up a password for all the
sheets at once.

I am also wanting a macro to select all of the sheets and remove the
password.