Hi all,
I need to setup a Audi Trail system for my excel workbooks and I found
this code on the net by google search.
-
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
Dim strFileName As String
strFileName = "Location\fil
the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----
________
From: Seba
To: MS EXCEL AND VBA MACROS
Sent: Thu, September 29, 2011 4:18:58 AM
Subject: $$Excel-Macros$$ Audit Trail
Hi all,
I need to setup a Audi Trail s
gt;
>
> Paul
> -
> “Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> ---
& vbTab _
> > & Target.Value
> > End If
> > Close #1
> > End Sub
> >
> >
> > Paul
> > -------------
> > “Do all the good you can,
> > By all the means you can,
> > In all the ways you can,
> > In all
ng as ever you can.” - John Wesley
-
From: Seba
To: MS EXCEL AND VBA MACROS
Sent: Thu, September 29, 2011 8:40:25 AM
Subject: Re: $$Excel-Macros$$ Audit Trail
Hi Paul,
thank you very much for aour effort. There is jus
o all the people you can,
As long as ever you can.” - John Wesley
-
From: Seba
To: MS EXCEL AND VBA MACROS
Sent: Thu, September 29, 2011 8:40:25 AM
Subject: Re: $$Excel-Macros$$ Audit Trail
Hi Paul,
thank you very
he people you can,
> As long as ever you can.” - John Wesley
> -
>
>
> From: Paul Schreiner
> To: excel-macros@googlegroups.com
> Sent: Thu, September 29, 2011 8:49:58 AM
> Subject: Re: $$Excel-Macros$$ Audit Trail
>
> Intere