Insert columns in protected worksheet?

R

Rich

Hi, Does anyone know how to insert new columns into a password protected
worksheet? Thank you!!
 
C

CBrine

activesheet.unprotect "YourPassword"
Activesheet.rows(12).entrirerow.insert
Activesheet.protect "Password"

HT
 
Top