Thread: Log Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SIGE SIGE is offline
external usenet poster
 
Posts: 206
Default Log Workbook

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 :o)

Sige