How do I keep other users from saving my read-only document?

[bumblebug]

I do not want other users to be able to do anything but look at my worksheet.
I do not want them to be able to save it, change it, forward it, anything.

[Nigel_hough]

I think what you want is quite easy if you open your workbook

Go to : Tools > Protection > Protect Workbook...

You should be able to enter a password then nobody will be able to edit the document without the password

Hope This Helps

[Peter Rooney]

Hi,

Not sure about stopping people from sending it, but you can certainly stop
people from saving it...
Go into Windows Explorer and find your filename in the appropriate folder.
Right click the filename
Left Click "Properties"
On the "General" tab, put a tick in "Read Only" and click OK

(Don't worry about them changing it when they open it - if they can't save
the changes, it doesn't matter!

Cheers

Pete
"bumblebug" wrote:

> I do not want other users to be able to do anything but look at my worksheet.
> I do not want them to be able to save it, change it, forward it, anything.

[Myrna Larson]

Of course the user can do the same thing, and remove the read-only attribute.

On Fri, 4 Mar 2005 02:17:06 -0800, Peter Rooney
<PeterRooney@discussions.microsoft.com> wrote:

>Hi,
>
>Not sure about stopping people from sending it, but you can certainly stop
>people from saving it...
>Go into Windows Explorer and find your filename in the appropriate folder.
>Right click the filename
>Left Click "Properties"
>On the "General" tab, put a tick in "Read Only" and click OK
>
>(Don't worry about them changing it when they open it - if they can't save
>the changes, it doesn't matter!
>
>Cheers
>
>Pete
>"bumblebug" wrote:
>
>> I do not want other users to be able to do anything but look at my
worksheet.
>> I do not want them to be able to save it, change it, forward it, anything.

[swatsp0p]

All of the measures available to 'secure' the data in a spreadsheet can be broken by someone so determined.

My recommendation is to always keep a backup of your file in a secured location (removable drive, private folder on the server, etc.).

If the data integrity is that valuable or sensitive, placing the file in a "limited access folder" is good idea, as well. Your System Administrator should be able to set that up for you. Give Read Only rights to a few selected users.

Good Luck