Excel Question

[Caveman]

I often imbed the "automatic" timestamp control codes into my headers so that the printed hardcopy of the spreadsheet shows the "time" so that anyone that looks at the hardcopy knows how "old" it is...

The problem is that the timestamp is keyed to the time it prints. So... A roomful of people looking at the same spreadsheet data might all have differnt times. Is there any way to key the timestamp to the time the file was last revised, instead of when it was printed?

 

[Thyme]

Will this work?

 

[Caveman]

I have no idea where to cut and paste that code... I don't even know if that was a joke : )

Help...

 

[Caveman]

bump...

 

[Thyme]

Go to Tools...Macro...Visual Basic Editor and paste it in there. You can then hit Run or run it from the Macros window. You'll want to change it to go to the cell you want it in. You'll have to work with it if you want to make it into a function.