View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gavmer[_68_] gavmer[_68_] is offline
external usenet poster
 
Posts: 1
Default Code cancels protection properties

Hi all,

Have a small prob. I run a code that unprotects then protects a shee
after running a copy/paste procedure. Prob is, after the code runs,
am no longer able to delete rows. Before the code ran i set th
protection to allow deletion of rows but running the code seems t
cancel this.

Is there a way round this??

Cheers all!

--
Message posted from http://www.ExcelForum.com