Record changes made from a vb form
Hi Dave,
Via the Worksheet_SelectionChange event, you can trace any
changs in the spreedsheet. Save the following example
under you spreedsheet code and try.
Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
With ActiveWindow
.ScrollRow = Target.Row
.ScrollColumn = Target.Column
End Sub
Best Regards
Bill
-----Original Message-----
Hi,
Can anyone give me some ideas on how to go about the
following:
I want want to record the changes a user makes to a
spreadsheet and save
them to a txt file or csv file with the following info:
Date and time edited
cell info changed from.
cell info changed to
User who made changes
(all changes will be text based)
Thanks for your help
Dave
--
Please remove "no.thanks."
and add "blue" in front of yonder to email me.
Sorry for inconvenience but feed up of spam mail
.
|