View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sharon C[_2_] Sharon C[_2_] is offline
external usenet poster
 
Posts: 2
Default Paste Special in protected sheet

Thanks - it works great

"Sharon C" wrote:

I need to perform copy paste special to replace formulas with values in a
protected sheet. Is there a macro that will unprotect and perform copy paste
special?