Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default Protecting an excell workbook

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excell automatically protecting a ws Alan Excel Worksheet Functions 5 December 22nd 08 08:38 AM
auto locking of excell workbook (excell 2003) cheekymonkey Excel Discussion (Misc queries) 2 November 14th 08 11:50 PM
Protecting a workbook Sasikiran Excel Discussion (Misc queries) 1 March 6th 08 10:05 PM
Excell-Protecting sheet formatting Didas Excel Worksheet Functions 0 March 22nd 07 10:14 PM
Protecting Workbook!.. Neo1 Excel Worksheet Functions 3 May 3rd 06 01:22 PM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"