Hi all,
I've looked everywhere for an answer and the only thing I could find is removing the encryption because someone forgot the password or are trying to break the code to get into the file. I already know the password. I have an extremely complex excel 2010 template that I want to keep safe from those who don't know excel well enough to make it work. With this template, twice a month, I refresh the data and update the pivots and run a macro to save a copy of the splash page, or a dashboard for lack of a better term, as a separate file. However, when I run the macro, the saved copy also has the encryption. I need my macro that I run to remove the encryption so those who want to view the separate file with the copy of the splash page/dashboard can do so freely without the need of the password. Please let me know how to accomplish this, thanks.
Yavihle