Excel Macro Question

[william_rollins]

Hi All,

I'm dealing with an Excel issue that's driving me crazy and I was
hoping someone could help me out with.

I'm working on a spreadsheet to track projects and I would like to
create a macro that would track and show the number of a days a
project has been opened for each time the spreadsheet is viewed or
opened.

If anyone can offer any assistance, I would greatly appreciate it!

-Tommy

 

[JE McGimpsey]

Any reason you can't use a formula? Perhaps something like

=TODAY()-A1

where A1 contains the date the project opened?

 

[william_rollins]

Any reason you can't use a formula? Perhaps something like

=TODAY()-A1

where A1 contains the date the project opened?







- Show quoted text -

I wish I could just use a formula but unfortunately I must use a macro
so everytime the page is viewed or opened "whether it's today or next
week". My spreadsheet will automatically show the number of days a
project has been opened.

 

[JE McGimpsey]

Since TODAY() is a volatile function, that formula will recalculate
whenever the sheet is opened or any other calculation occurs.

So I don't understand what you see the macro doing differently...

For instance, what should trigger the macro to recalculate (other than a
sheet calc or opening the file)?