hello,

I have a workbook that i password protected with a user form to stop people saving changes
it is created as template program to process and graph data.
the reason i have had to stop anyone saving the workbook is that i run filters in sheets and saving the book after the filter has run makes it go from 5Mb to 150Mb.

I would like to run a macro that can automatically fill the password into the user form click the enter button and save the changes to the workbook

thanks in advance