ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to found changed cells? (https://www.excelbanter.com/excel-discussion-misc-queries/99259-how-found-changed-cells.html)

slaya_cz

How to found changed cells?
 

Hi there

I have worksheet which uses ten users. Is there some possibility when I
open this worksheet, that I can see what is the latest change (or last
10 changes)?
I assume it can be done using some macro. However, is there some other
way?

Thanks all

SL


--
slaya_cz
------------------------------------------------------------------------
slaya_cz's Profile: http://www.excelforum.com/member.php...o&userid=16723
View this thread: http://www.excelforum.com/showthread...hreadid=561425


Dave Peterson

How to found changed cells?
 
Maybe you could turn on Tools|share workbook and tools|Track changes.

Be aware that there are lots of features disabled when you share the workbook.

See excel's help for a list.

slaya_cz wrote:

Hi there

I have worksheet which uses ten users. Is there some possibility when I
open this worksheet, that I can see what is the latest change (or last
10 changes)?
I assume it can be done using some macro. However, is there some other
way?

Thanks all

SL

--
slaya_cz
------------------------------------------------------------------------
slaya_cz's Profile: http://www.excelforum.com/member.php...o&userid=16723
View this thread: http://www.excelforum.com/showthread...hreadid=561425


--

Dave Peterson


All times are GMT +1. The time now is 03:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com