Pivot Table and Protection
 

I created a macro to update my pivot tables when the worksheet is protected.
It works fine as long as I know the password (i.e., I must enter the password
to run the macro). This really defeats the purpose of the protection. So my
question is how can other users update my pivot tables without knowing my
password? I'm using 2003 version. Thank you!
--
Catherine