From: "Robert Rosenberg" <bladeX@email.msn.com>
Subject: Re: Prevent copying of cell contents?
Date: Thu, 25 Nov 1999 10:41:22 -0800
Newsgroups: microsoft.public.excel.misc

Not that I know of, though you can prevent them from selecting any cells for
any reason using the following VBA code...

Private Sub Auto_Open()

    Dim sht As Object
    Dim wks As Worksheet
    For Each sht In ThisWorkbook.Sheets
        If TypeOf sht Is Worksheet Then
            set wks = sht
            wks.EnableSelection = xlNoSelection
        End If
        sht.Protect Password:=CStr(xlNoSelection)
    Next sht

End Sub

This routine will automatically run when the workbook is open. It can be
circumvented by holding down the Shift key while openeing the workbook.  The
EnableSelection property only works on worksheets (not chart sheets, for
example) and only takes effect when you protect the worksheet, and needs to
be set each time the workbook is opened. Just so you know, I set the
password equal to the constant xlNoSelection, which in reality represents
the number -4142. To unprotect the sheets programmatically, use...

Private Sub UnprotectSheets()

    Dim sht As Object

    Dim wks As Worksheet
    For Each sht In ThisWorkbook.Sheets
        sht.unprotect Password:=CStr(xlNoSelection)
    Next sht

End Sub

The use of the word Private in each routine prevents them from appearing in
the Tools-->Macro-->Macros dialog. To completely protect these macros,
you'll need to access the Visual Basic Editor, right-click the file/project
name in the Project Explorer window (usually on the left side of the
screen), and go into the Protection Tab.

This is probably more info than you wanted, so if any of it seems unclear,
please post back for step by step instructions.
_______________
Robert Rosenberg
RCOR Consulting
Microsoft MVP - Excel

http://ntware.com

Wright TC <wrighttc@concentric.net> wrote in message
news:383D6CF9.C79D50E1@concentric.net...
> While protecting a worksheet in Excel 97 prevents any changes to locked
> cells, is there also some way to prevent those cell contents from being
> selected aand copied, then pasted into another document?
> I know other programs (e.g., Adobe Acrobat Exchange) that have this
> feature, but I haven't been able to figure out how to do it in Excel.
> Overlooking something simple, I hope?
> Thanks for any suggestions.
> David Wright
>