Workbook Protection on a Shared Workbook

[Mark McDonough]

Is there some way that I can password protect a an xl workbook that is also
shared. The intention is to have a file that calculates freight rates
available to marketers without them stuffing up the formulas in it.

I know how to protect certain cells from being edited and others ok for
input but not sure about how to prevent the salesmen from editing the
formulas. Any ideas anyone?

Regards
Mark

 

[Earl Kiosterud]

Mark,

The protection you need is worksheet protection (Tools - Protect - Protect sheet). That is
independent of sharing the workbook. Sheet protection is a two-step process. First unlock
the cells that are to be allowed changed (Format - Cells - Protection - deselect locked),
then protect the sheet (Tools - Protect - Protect sheet). A password can be specified to
prevent users from removing the sheet protection, but is not effective enough for determined
users, who can get password crackers -- it's more just to keep the honest people honest.

If the workbook is currently shared, you'll have to un-share it while you set up the
protection, then re-share it. You'll lost the change history, and no one else should have
it open while you're doing this.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...