Need help sharing and protecting an Excel doc

November 15, 2010 at 12:26:59
Specs: Windows XP
I have an Excel spreadsheet which needs to be edited by 5 remote users and viewed (but not edited by approximately 45 remote users. Most of the editors are not very computer saavy. I've attempted to utilize posting a copy of the spreadsheet in Dropbox, but Dropbox allows the user to open a copy and modify it, despite the document having been Locked and the sheet Procted. - Is there a simple way for me to password protect the document, put it somewhere that all the users can access it in a 'view only' mode and allow the editors to open it, enter the password, make their changes, procted it, close it and have it available for all to view? I'm using a mac, most of the others are on Windows XP. Any help would be really appreciated!!! I need to present a solution to this group this weekend.

See More: Need help sharing and protecting an Excel doc

Report •

#1
November 15, 2010 at 16:20:16
If your editors will know the password - and you trust them to protect the document after they edit it - why can't you just put the document on a network drive that all users have permission to access?

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

#2
November 16, 2010 at 06:19:04
Thank you for your response. My problem is that none of the users are on a network. They are all working from a home pc. I've got to figure out a way to either get Dropbox to honor the spreadsheet protection (because currently a user can open and locked and protected spreadsheet in Dropbox and modify it without a password) - or - find someway to post the sheet other than Dropbox. I would consider G-mail, but very few of the users have a G-mail account. Any thoughts?

Report •

#3
November 16, 2010 at 06:40:34
I don't kniow anything about Dropbox, so I can't tell you why the users can edit a protected sheet.

If Dropbox is removing the protection, then maybe you couid add an Open event macro that protects the sheet when the user opens it on their PC.

Of course, that would (might) only work if Dropbox allowed macros to run when the file was opened.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

Related Solutions

#4
November 16, 2010 at 08:15:52
That's a good idea. Let me check it out. Thanks!

Report •

Ask Question