Posted to microsoft.public.excel.programming

external usenet poster

Posts: 109

Timestamp Saved

I have the following code:

Private Sub Workbook_Open()
Worksheets(1).Range("A1").Value = Now()
End Sub

This shows current date and time but i only need it to change if workbook is
modified. This code will be within a workbook that is sent from one country
to another and needs to maintain its orginal timestamp.Can this be done?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
TimeStamp	Chris	Excel Discussion (Misc queries)	2	April 19th 10 10:15 PM
How do I recover an Excel document saved not saved as	Darryl	Excel Discussion (Misc queries)	6	January 5th 10 03:39 AM
Timestamp	juanpablo	Excel Discussion (Misc queries)	3	November 2nd 07 01:55 PM
Timestamp	PS	Excel Discussion (Misc queries)	2	January 10th 07 02:21 PM
Timestamp	Starryeyedmusician	Excel Programming	1	February 5th 06 05:53 AM

All times are GMT +1. The time now is 07:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us