LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
tj tj is offline
external usenet poster
 
Posts: 71
Default automatically enter today's date as a static entry in Excel

Good day,

I have a spreadsheet where when this is opened I would like the time/date it
was opened to be static so I can know when the last changes were made.

I have created a macro button for paste special but is there away to do this
without clicking somewhere meaning as soon as the file is opened the time
/date gets stamped in a particulr cell without hitting save?

Appreciate anyone's help on this

thanks
TJ
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
in excel how do enter today's date on a laptop bency New Users to Excel 3 August 30th 05 01:37 AM
in excel how do enter today's date on a laptop bency New Users to Excel 1 August 25th 05 01:28 PM
in excel how do enter today's date on a laptop bency New Users to Excel 1 August 25th 05 12:39 AM
Automatically enter today's date as a static entry David Links and Linking in Excel 2 June 6th 05 12:08 AM
Automatically enter today's date as a static entry David Excel Worksheet Functions 1 June 4th 05 04:54 PM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"