Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2006

Tip: Looking for answers? Try searching our database.

Shareing a workbook with one user

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nancy S. - 23 Mar 2006 18:01 GMT
I have a workbook that I allow read only capability to nine other guys. One
of these guys also needs update capability. How can I set it up to give one
person update capability but the others read only capabilities.
EdMac - 24 Mar 2006 11:49 GMT
How about giving him the password - you obviously trust him to make
changes.

Signature

EdMac

Nancy S. - 24 Mar 2006 15:42 GMT
It is not password protected. The workbook is on my computer and I would like
to be able to give him update capabilities while leaving it read only for the
other guys.
Nancy

> How about giving him the password - you obviously trust him to make
> changes.
jinx2311 - 24 Mar 2006 20:03 GMT
Maybe instead of putting it on your local disk only, you could put the
file on a network drive after enabling workbook protection with
password. That way, everyone will be able to access and read it, but
only you and the other guy will have the passwords and hence the
capability to actually edit.

I have done this for a number of my work files, and it has worked great
for me! Hope it does for u too!
EdMac - 27 Mar 2006 13:36 GMT
Hi Nancy,

To stop others modifying you need some kind of password protection.

Go to Save as, on the screen in the top right hand corner click on
tools - this will give you some options and only those with a password
can modify.

Ed

Signature

EdMac

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.