Re: Track Changes - Text and Formulas with user name and time stamp

[Looking4sum1]

Im a Newbie here. I saw a post about the above mentioned title by arkusM (w w w.vbaexpress.com/kb/getarticle.php?kb_id=1074) and I've adapted to my workbook and it works.


However, for the other workbooks that I have...is there a way thru vba to track only the specific sheet/s with specific range/s (e.g. Sheet2'!$A$1:$H$5, Sheet4'!$B$4)? and is there a way also to delete the sorted specific sheet/s in the Cell Changed of the "Tracker" Sheet (e.g. all Sheet2'!$U:$1 & Sheet4'!$D$3:$G$8)? May I know the code if there is? The reason is to record only the important ones and not to get flooded.

KB Link (http://www.vbaexpress.com/kb/getarticle.php?kb_id=1074)

Many thanks in advance.


Arvie

[SamT]

It would help if we could see the adapted code


is there a way thru vba to track only the ... specific range/s (e.g. Sheet2'!$A$1:$H$5,
That parts easy.

if intersect(Target, Range("$A$1:$H$5")) is nothing then Exit