Hello Dear
If your workbook is in share mode,you can trace the authenticate user,who has
made the changes...
Just try to
check:
Worksheets("Sheet1").OnEntry
If true then report or save the log with user name and machine id.
I am just giving idea,for full programe it will take time.
Hope
can you elaborate unauthroised access /
On Thu, Apr 1, 2010 at 12:04 AM, seema mba wrote:
> Hello Master,
>
> I have got a macro to track changes made in excel sheet. But the changes
> are tracked in sheet1 of the same work book. I want a macro which keeps the
> track of changes, in a different