This may be a real easy question but I can't find it in the help file. How
do you put a write protect on a workbook that will not allow someone who
opens it to save/copy/print? An example for use would be a financial type
document.

I think you'll find your answer he

http://www.brainbell.com/tutorials/m...in_Actions.htm

"Dustin B" wrote in message
...
This may be a real easy question but I can't find it in the help file.
How
do you put a write protect on a workbook that will not allow someone who
opens it to save/copy/print? An example for use would be a financial type
document.

But don't forget that anyone who can open the workbook can copy entire sheet
ranges to a blank workbook.

You can protect the book to prevent sheet copying and protect the sheets so's
users can't select cells to copy.

BUT............

I can open a new work book and enter

'='C:\Program Files\Microsoft Office\exceldata\[Book2.xls]Sheet1'!A1

and retrieve the info to manipulate as I choose.

General rule is............if you don't want people to access and distribute
your personal and sensitve information, don't include it in the workbook.


Gord Dibben MS Excel MVP

On Mon, 28 Jan 2008 19:06:03 -0500, "Bob" wrote:

I think you'll find your answer he

http://www.brainbell.com/tutorials/m...in_Actions.htm

"Dustin B" wrote in message
...
This may be a real easy question but I can't find it in the help file.
How
do you put a write protect on a workbook that will not allow someone who
opens it to save/copy/print? An example for use would be a financial type
document.