View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
gibbylinks
 
Posts: n/a
Default Recording changes

Thanks Steve.. This is exactly what I was looking for..........but
We're having problems when more than one person opens the spreadhseet at the
same time. Is it possible to have the spreadsheet locked i.e only avaliable
as read only for other users, untils it's "released"

Defeats the object of "sharing" I know, but we only want the
tracking/history information.

Thanks

"SteveG" wrote:


Paul,

See "About tracking changes" in the Excel Help File.

You can have the changes tracked in a shared workbook either directly
in the sheet where the changes were made or on a separate history page
(which you could protect and hide from other users).


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=488740