Password proctected shared workbook

taz23340

Active Member
Joined
Jun 11, 2003
Messages
336
Hi all,
I have a workbook that is on a network drive at work. I want it to be shared so that more than one person can update it.
I have done this.
I also want it to be password protected so that only the few that need to can change data.
However, I cannot do both tasks.
When I password protect a book and then share it, I must unshare it to be able to enter the password to unproctect the book.

this defeats the purpose of being able to protect it.

i`ve attempted to view the help files but i do not want to use vba for this case.

any help would be greatly appreciated
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
If it's on a network you can have your network admin set the rights to the document, so only specific users can open it with Read/Write access.

HTH,

Smitty
 

taz23340

Active Member
Joined
Jun 11, 2003
Messages
336
hey pennysaver, long time no speak,
thanks for the idea.

however, as mr excel says himself, we have to do things without IT helping.

also, i would like for all to be able to see but only a few able to update it. but i need those who can update it to not have to wait for those who are viewing to get out.

i hope i make sense there.

thanks
 

Forum statistics

Threads
1,181,102
Messages
5,928,062
Members
436,586
Latest member
latintxn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top