View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
pam pam is offline
external usenet poster
 
Posts: 11
Default Prevent copying sheet

I found the answer, just un-select the box in the
Protection list for "select locked cells". Too easy.
-----Original Message-----
Is there a way, via VB code, to prevent someone from
copying information (individual cells) and pasting them
into another document. My spreadsheet is on a secure
internet system and is password protected.The problem we
are encountering is people copying selected cells from
the spreadsheet, pasting them into another spreadsheet,
and them making formula changes. This is what we need

to
avoid to ensure everyone is using the same spreadsheet.
Any assistance would be greatly appreciated
.