Can anyone help please.
I have a shared workbook which is to be used as a booking diary, is there
any way that editing a cell by more than one user can be stopped. I know
that changes can be tracked, but my understanding is they only show up when
the last person saves the file.
Any help would be appreciated.
--
daver
You can go into properties/security for that workbook and change the
user settings.
Or protect the cells that you do not want altered.--
keithl816
------------------------------------------------------------------------
keithl816's Profile: www.excelforum.com/member.php...oamp;userid=21287
View this thread: www.excelforum.com/showthread...hreadid=518731Or/and create a 'log' file, to record changes in your book, by VBA code.
quot;Daverobquot; gt; escribió en el mensaje
...
gt; Can anyone help please.
gt;
gt; I have a shared workbook which is to be used as a booking diary, is there
gt; any way that editing a cell by more than one user can be stopped. I know
gt; that changes can be tracked, but my understanding is they only show up
gt; when
gt; the last person saves the file.
gt;
gt; Any help would be appreciated.
gt; --
gt; daver
- Aug 14 Mon 2006 20:08
Editing in a multi-user environment
close
全站熱搜
留言列表
發表留言