The Fort Wayne Chapter of the IIAFORT WAYNE. IN - 2018-04-18

Excel Daily News

Featured Product

Last Update

I'm trying to get a cell on my worksheet to display the last update time of the sheet.

Can anyone tell me how to accomplish this? The NOW() function and the TODAY() function are not what I'm looking for - I need the date/time of the last time the sheet (or a range of cells) were modified.

I must be stupid - I did as you instructed, and also found a few other procedures similar to yours (on this page - further down) but I don't see any result!?

What the...???

Am I supposed to compile these some how? Sorry - I'm not a VB guy. I'm a software engineer - but don't play with MS products.

Thanks much in advance!!!

Mark.

Posted by on January 10, 2002 4:23 PM

I even figured out to compile them - still, I see nothing in any of my three sheets!

What's the problem here...

I'm on AIM <Luv2CatchBass>

Mark

Posted by Goneril on January 10, 2002 4:54 PM

Copy the two proceduresRight click on the sheet tabSelect View CodePaste the procedures onto the window on the right-hand side

Posted by Mark on January 10, 2002 5:04 PM

I did that - I see nothing on my sheet - the code is there - nothing in A1.

Mark.

Posted by Goneril on January 10, 2002 7:09 PM

Make sure the code is in the Sheet's code module, not in a normal code module.

Also, for a date/time to appear in A1, an input from the keyboard has to be made to the sheet or a formula(or link) has to be updated/calculated.

Posted by Mark on January 11, 2002 9:37 AM

Also, for a date/time to appear in A1, an input from the keyboard has to be made to the sheet or a formula(or link) has to be updated/calculated.

--- Just for the record, the problem was with my Macro Security Settings - It was High - and that's no good. (well - it's good, but it prevented your code from running on my machine!) I set it to Med, restarted Excel and it all works as advertised... So next time you can tell the person it will work if the macros securtiy setting is NOT set to High...

(9 responses) Hello all, I am new to the world of VBA and just started working on creating macros about 5 weeks ago. I have been watching YouTube videos a

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View my Privacy Policy and Terms of Use.