Prev: Reloading and Editing UserForms in Excel - help!
Next: IS it possible to get the Visual Basic Form to VBA Excel
From: Catherine on 24 Mar 2010 18:34
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!