<div>
Oh and of course change &quot;sheet1&quot; and &quot;A1&quot; to reflect the sheetname and cell that you want the date stored in.
</div>


Oh and of course change "sheet1" and "A1" to reflect the sheetname and cell that you want the date stored in.

<div>
Neilsr,<br />
<br />
I'm not sure what I'm doing wrong..... I cut/pasted your code into the Company_Profile tab in the Developer's tab, changed the spreadsheet name and the cell reference and saved/closed the workbook. &nbsp;When I opened it....nothing. &nbsp;I'm running 2010 if that makes any difference and I do have macros enabled............ any ideas?<br />
<br />
B.
</div>


Neilsr,

I'm not sure what I'm doing wrong..... I cut/pasted your code into the Company_Profile tab in the Developer's tab, changed the spreadsheet name and the cell reference and saved/closed the workbook.  When I opened it....nothing.  I'm running 2010 if that makes any difference and I do have macros enabled............ any ideas?

B.

<div>
Oh... changed it to &quot;This Workbook&quot; and it worked great! &nbsp;Much thanks.<br />
<br />
B. 
</div>


Oh... changed it to "This Workbook" and it worked great!  Much thanks.

B.

<div>
By the speed and simplicity, I'll take it as a &quot;yes&quot; that was easy!<br />
<br />
Thanks,<br />
<br />
B.
</div>


By the speed and simplicity, I'll take it as a "yes" that was easy!

Thanks,

B.

<div>
Developers tab, visual basic, paste code into This Workbook
</div>


Developers tab, visual basic, paste code into This Workbook

<div>
<div class="content wysiwyg-content">
I have a spreadsheet and each time I open it it displays the current date. &nbsp;I'd like a command or small macro that places in the cell below the current date the date the spreadsheet was last worked on. &nbsp;If I use a simple copy/paste, it too will auto update each time I open the sheet. &nbsp;Just to be clear, when the sheet is closed and then reopened a new date time will be established and the old one moved into the &quot;date spreadsheet was last worked on&quot;.<br />
<br />
Hard or easy?<br />
<br />
B.
</div>
</div>


I have a spreadsheet and each time I open it it displays the current date.  I'd like a command or small macro that places in the cell below the current date the date the spreadsheet was last worked on.  If I use a simple copy/paste, it too will auto update each time I open the sheet.  Just to be clear, when the sheet is closed and then reopened a new date time will be established and the old one moved into the "date spreadsheet was last worked on".

Hard or easy?

B.

Last Update Date

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.