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