View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Enable Copy and Paste Functions in a protected worksheet

copy the entire worksheet into a empty workbook. The new workbook will not
have any protection.

"LRay67" wrote:

How do I go about letting users utilize the copy and paste function when
worksheet is protected?

Thanks

Linda