you have add a line to your code for the macro:
ActiveSheet.Unprotect Password:="your password"
then at the end, just before End Sub Add
ActiveSheet.Protect Password:="your password"
This will allow your macro to disable your password protection, excute the macro and reprotect itselt all with one click.