View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Locking Excel for Editing

doesn't that happen automatically? On your network, can multiple open and
edit one file? That would be odd.

"pslaught" wrote:

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!