Automatic Date - No VBA

[rook114]

Is there a way to modify the date in which a range of cells was updated without adding any code to it?

I will have multiple ranges with individual dates on the same sheet, making the NOW function not possible.

Thanks for your help.

 

[chrysti]

can you use the:
=TODAY()
that will give you today's date everytime you open

 

[rook114]

Right, but I need there to be different dates as certain users will update the sheet on different dates.

The function is to show when the user has last changed something in their range of cells, not necessarily when they opened it.

 

[HalfAce]

Hello rook114, welcome to the board.
I don't think (off hand anyway) you'll be able to do this without the use of some vba.
Is that not an option at all? - or would some vba that executes automatically (without
having to be initiated by the user) be acceptable?

 

[rook114]

I had code in the sheet that performed what I wanted it to do, however with different users, the update worked on some, but not others. I can only suspect this is due to security settings. I don't know what else could have caused it.

Your thoughts are appreciated.

 

[HalfAce]

So... you have the code you need and the issue is just to 'force' the user(s) to have
macros enabled on their machine(s)?

If that's the case there are a number of threads that deal with that.
(Search for 'force AND macros AND enabled'.)
Here's a link to one that may help get you started.
http://www.mrexcel.com/board2/viewtopic.php?p=148963#148963

Hope it helps. Let us know if I'm misunderstanding what you meant.

 

[rook114]

I would like to be able to do the task of the code without any code. I would rather not force users to change their security settings or to have any VBA in the file at all.

I'm not sure that it's possible. Just a thought.