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

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
.

TOOLS[/b] *PROTECTION* *PROTECT SHEE
Play around with the settings until you get exactly what you're lookin
for.

Right click a range of cells and select [b]Format Cells*. Select th
last tab, *Protection*. Hidden cells have their formulas hidden wen th
cell is selected. Locking a cell just sets the locked flag on the cell
to be manuipulated by Sheet Protection.


-Gitcyphe

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