Set up a workbook that 2 users can change all others read on

jsosi · Apr 11th, 2002, 08:52 AM

How do you set up a (on a network) workbook so two users can update and all others are read only.

HOTDOG · Apr 13th, 2002, 03:15 PM

You could save the book with a "Password to Modify". Anybody could then open the book as read only but ony those that know the password could cange the data.
Select the OPTIONS button on the Save As dialogue box.
You could also Share the book so the two users could modify it at the same time.

HTH

Brian from Maui · Apr 14th, 2002, 12:37 AM

Have your IT department set-up a shared folder on the network, with read and write permission for the two people with user names and passwords. For all others just read only.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 08:52 AM	#1
jsosi New Member Join Date: Apr 2002 Posts: 1	How do you set up a (on a network) workbook so two users can update and all others are read only.

Apr 13th, 2002, 03:15 PM	#2
HOTDOG New Member Join Date: Mar 2002 Location: Northern Ireland Posts: 6	You could save the book with a "Password to Modify". Anybody could then open the book as read only but ony those that know the password could cange the data. Select the OPTIONS button on the Save As dialogue box. You could also Share the book so the two users could modify it at the same time. HTH

Apr 14th, 2002, 12:37 AM	#3
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,767	Have your IT department set-up a shared folder on the network, with read and write permission for the two people with user names and passwords. For all others just read only.