Protected sheet: Macro to insert/delete colums 1

[DajOne]

I created a macro that unprotect a spreadsheet, select the appropriate colums and insert them somewhere else. My problem is the macro does not work if I apply a password to the protection.. I looked into a VBA dictionnary to no avail with my limited knowledge...

Any ideas to allow the macro to remember the password?

Thanks

 

[bandit600]

Is this what you are after

Worksheets("sheet1&quot.Protect password:="letmein"

bandit600

 

[DajOne]

That is it !!!

I tried the same to unprotect the sheet and the error messsage states that my password is incorrect.... and i triple checked it and it's the right one.. Is there an unprotect command?

Worksheets("sheet1&quot.UnProtect password:="letmein"