Log Workbook

[Sige]

Hi All,

I am having quite some inspiration these days ...

Is there a way to track changes which have been done on a workbook?

What I am sort of thing of is the following:
-I have 1 Veryhidden sheet which serves as "Change track" report
-This sheet tracking:
- Date of change
- Who changed it? : Username
- Which cells changed
- Previous cell value
-Workbookstructure changed? (worksheets inserted? ...)
-(Formatting changes not)
- ...other useful info

Looking forward to your inspiration )

Sige

 

[STEVE BELL]

Check out Shared Workbook - these can be set to track changes.
also use the help and find "track changes"

You can also put in a Workbook Change macro in the ThisWorkbook Module and
have it fill the tracking sheet with what ever you can capture. The tricky
part is capturing the initial value - you might be able to capture this on
the selection change event and feed it into the change event code.

Just remember that in an event macro Target is the cell selected or changed.
Date is today's date and Now() is date and time, check out User or UserName.

Not sure about formatting, inserting pages, and other major events.

If your entries start in column A, than you can always find the first open
cell with something like
rw = worksheetfunction.Counta(Sheets("MySheet").Columns(1)) + 1

 

[Sige]

Hi Steve,
Thanks for the your valuable info!

-I don't think Shared Workbooks are an option ... it should be
functional for XL97.
-I am sure that some clever NG-member has already tested sortlike code
.... I hope it at least.

Could not find much Browsing the NG on "log workbook".
It would me take ages to top all problems ahead. (Admitting it is the
best learning school but seen the time I spend already on it...I get
serious familial problems)

Just alreading thinking about the volatile functions you are mentioning
....! The report would not value much if I get updates on every second
the NOW() function has changed.

Cheers Sige

 

[STEVE BELL]

Sige,

Sorry I couldn't be of more help. It has been a long time since I used
xl97.

You might want to get the google search add-in. It's free and makes it
easier to find things concerning Excel. It also has some good sites listed:
http://www.rondebruin.nl/Google.htm

But you can use Now() in code and get a static entry in the worksheet. It
only changes if it is entered into a worksheet cell as a formula.
Range("A1")=Now()
Range("A1")=Date
You should be able to format them anyway you want
Range()=Format(Now(), "mmm d, yyyy") (or anything you can dream up -
including hr/min)

Be sure to check out event macros - they should work for you.

Post back if you need more...

I'm using xl2000, but might be able to come up with some stuff for you, just
ask...
You can email me direct to make sure I see your post...

 

[Sige]

Hi Steve,

Ron's Google search is my way ..and only one to search the NG!
Super-practical I agree.

Maybe I have to set my search date further back in time ... Lets try.
Sige