It's not possible. Any solution that prevents copying would rely on macros.
But a user could thwart that by disabling macros. Excel is simply not a
good repository of sensitive information.

--
Jim
"kfrost" wrote in message
...
| Update:
|
| What I've found is the password is staying in place. However if you
select
| all the cells in the protected document and the copy them and past them
into
| a different workbook. All the hidden cells are copied and displayed in
the
| new work book. So it appears I'm looking for a way to disable the
copy/cut
| functionality from the worksheets.
|
| Any ideas?
|
|
|
| "kfrost" wrote:
|
| Hello,
|
| I have a customer who has sale people that have product spreadsheets for
| pricing. They have wholesale and retail pricing on the same sheet. The
| wholesale prices they hide and password protect, however, the problem is
you
| can open the spreadsheet in read only mode and then save a copy of it.
Then
| open the saved copy and the password protection is then removed.
|
| I'm trying to find a way to prevent this. However in searching it
appears
| that the password is pretty much insecure any way. So my thoughts are
using
| MS office tools for VS and creating an Excel Project and hard coding the
| password into the document for them.
|
| First of all if anybody has a better suggestion on how to secure these
| hidden cells where only sales person have access to them, I would love
to
| hear it. Secondly if building and compiling the app is the best way,
does
| anybody have a sample for VB.Net?
|
| Thanks.
|
| kris
|
|