Hi,
Is there a way to log all activities on one of the sheets, everytime there is an event like open by, save by, or changes made and date/time stamp with out sharing the workbook.
Thank you
Julio
Hi,
Is there a way to log all activities on one of the sheets, everytime there is an event like open by, save by, or changes made and date/time stamp with out sharing the workbook.
Thank you
Julio
Life is not as complicated as we think it is, we make it complicated.
IF you can change it, then strive for excellence.
IF not, then let it happen, don't worry about it and live a happier life.
Let's Have Fun!
Julio
see John's kb entry:
http://vbaexpress.com/kb/getarticle.php?kb_id=464
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Thank you it worked perfect.
Life is not as complicated as we think it is, we make it complicated.
IF you can change it, then strive for excellence.
IF not, then let it happen, don't worry about it and live a happier life.
Let's Have Fun!
Julio
I'll mark this one solved for you, Julio.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!