INsert this line at the begining of your code, to unprotect worksheet, a macro cannot make those changes on a protected sheet:
activesheet.Unprotect Password:="Secret"
At the end of the code, you may want to protect it :
Activesheet.Protect Password:="Secret"
|