View Single Post
 
Old 02-25-2012, 10:45 PM
Catalin.B Catalin.B is offline Windows Vista Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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"
Reply With Quote