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

I need to have the worksheet protection so the users do not mess with the
function that was built into the worksheet. Is there a code that would allow
users to copy and paste?

"Bob" wrote:

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