Hi

This is default behavior, you don't have to do anything but saving the sheet
on a shared drive.

HTH. Best wishes Harald

"pslaught" wrote in message
...
I have a spreadsheet that is available on a shared drive at work.

I've seen it done before where, once the spreadsheet is open by one
person,
everyone else can only open it as "read-only." The first person to open
the
spreadsheet has the ability to edit it -- thereby, only one person can
edit
the spreadsheet at a time.

How do I do this?

Thanks!