Yavhile
05-08-2018, 03:33 PM
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
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