I need to produce a 'time-stamp' to work in a number of Microsoft Excel Workbooks. The project requires the following;
i) Populate an excel worksheet cell with the time/date the file was first created, not the current time/date i.e. not =now()
ii) Populate an excel worksheet cell with the time/date the file was last modified.
iii) Populate an excel worksheet cell with the number of times the file has been modified.
All three cells must be locked and be unabled to be modified by the user.
The code should run in the excel worksheet as VBA code, and be transferable between workbooks i.e. a generic code to produce the 'time-stamp' in any workbook that requires this feature.
Windows XP and Microsoft Office XP Professional