Hi All........
If someone would be so kind.........I would like to know if it's possible to
build a log to a RangeName on a helper Sheet, returning the Name of each
macro as it is run, the datetime, and the ComputerUserName who ran the
macro, appending to the bottom of the Range each time any macro in the file
is run. It would be acceptable to insert a small snippet of code into each
existing macro, if necessary.

TIA
Vaya con Dios,
Chuck, CABGx3

sub LogMessage(sMacro as string)
with this workbook.sheets("log").cells(rows.count,1).end(xlU p).offset(1,0)
.value=Date
.offset(0,1).value = Environ("username")
.offset(0,2).value = sMacro
end with
end sub

or something like that.

Tim


"CLR" wrote in message ...
Hi All........
If someone would be so kind.........I would like to know if it's possible to
build a log to a RangeName on a helper Sheet, returning the Name of each
macro as it is run, the datetime, and the ComputerUserName who ran the
macro, appending to the bottom of the Range each time any macro in the file
is run. It would be acceptable to insert a small snippet of code into each
existing macro, if necessary.

TIA
Vaya con Dios,
Chuck, CABGx3

Hi Chuck,
Jon Peltier's article may help you get started:

http://pubs.logicalexpressions.com/P...cle.asp?ID=622

Debra

CLR wrote:
Hi All........
If someone would be so kind.........I would like to know if it's possible to
build a log to a RangeName on a helper Sheet, returning the Name of each
macro as it is run, the datetime, and the ComputerUserName who ran the
macro, appending to the bottom of the Range each time any macro in the file
is run. It would be acceptable to insert a small snippet of code into each
existing macro, if necessary.

TIA
Vaya con Dios,
Chuck, CABGx3








--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thanks Tim........that seems to point the direction

Vaya con Dios,
Chuck, CABGx3


"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
sub LogMessage(sMacro as string)
with this
workbook.sheets("log").cells(rows.count,1).end(xlU p).offset(1,0)
.value=Date
.offset(0,1).value = Environ("username")
.offset(0,2).value = sMacro
end with
end sub

or something like that.

Tim


"CLR" wrote in message
...
Hi All........
If someone would be so kind.........I would like to know if it's
possible to
build a log to a RangeName on a helper Sheet, returning the Name of each
macro as it is run, the datetime, and the ComputerUserName who ran the
macro, appending to the bottom of the Range each time any macro in the
file
is run. It would be acceptable to insert a small snippet of code into
each
existing macro, if necessary.

TIA
Vaya con Dios,
Chuck, CABGx3

Thanks Debra, I'll check it out......

Vaya con Dios,
Chuck, CABGx3




"Debra Dalgleish" wrote in message
...
Hi Chuck,
Jon Peltier's article may help you get started:

http://pubs.logicalexpressions.com/P...cle.asp?ID=622

Debra

CLR wrote:
Hi All........
If someone would be so kind.........I would like to know if it's
possible to
build a log to a RangeName on a helper Sheet, returning the Name of each
macro as it is run, the datetime, and the ComputerUserName who ran the
macro, appending to the bottom of the Range each time any macro in the
file
is run. It would be acceptable to insert a small snippet of code into
each
existing macro, if necessary.

TIA
Vaya con Dios,
Chuck, CABGx3








--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html