close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()