Prev: Lookup Formula
Next: Removing spaces from middle of cell
From: cufc1210 on 21 Apr 2010 12:21
I have a workbook which has 15 worksheets in it. It is on a network drive so
other people can access it.

I want to allow people to view the workbook without having to enter a
password but i dont want them to be able to edit it.

Any suggestions on how I do this will be much appreciated

Many Thanks
cufc1210
From: Mike H on 21 Apr 2010 12:36
Hi,

I would use Windows to do this. In Windows Explorer, right click the file
and set it's property to read only. It won't stop people changing it but it
will stop them saving with the same filename and given the level; or lack of,
Excel security IMHO it's as good as any method.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"cufc1210" wrote:

> I have a workbook which has 15 worksheets in it. It is on a network drive so
> other people can access it.
>
> I want to allow people to view the workbook without having to enter a
> password but i dont want them to be able to edit it.
>
> Any suggestions on how I do this will be much appreciated
>
> Many Thanks
> cufc1210
From: trip_to_tokyo on 21 Apr 2010 12:41
EXCEL 2007

Take the following actions:-

1. Office Button (top left hand corner).

2. Save As

3. Click on the Tools drop down arrow in the lower right hand corner.

4. General Options . . .

5. General Options window should launch.

6. Enter a password in the:-

Password to modify:

- field only.

OK

Enter password again and hit OK again.

7. Save the file and close it.

TO CHECK THE ABOVE HAS WORKED

8. Open the file again.

9. Password window should launch.

10. Select Read Only.

11. Try to amend the file and you will not be able to.

Please hit Yes if my comments have helped.

Thanks.





"cufc1210" wrote:

> I have a workbook which has 15 worksheets in it. It is on a network drive so
> other people can access it.
>
> I want to allow people to view the workbook without having to enter a
> password but i dont want them to be able to edit it.
>
> Any suggestions on how I do this will be much appreciated
>
> Many Thanks
> cufc1210
 | 
Pages: 1
Prev: Lookup Formula
Next: Removing spaces from middle of cell