Excel approval cell

[Ish]

Hi

I'm not sure what you call this so not having much luck finding it on Google.

In Excel what I want to do is have a cell which if the user clicks a button or similar it will show his username/time/date so in affect this will be their approval.

I hope that makes sense!

 

[wesimmo]

You'd have to use VBA and create a string from the system time/date and Application.UserName.

Then have the button put that string in the cell.

That said, I'm not sure what you're attempting to do is going to be the best solution if you need to lock all this down. If approval or not has serious implications, it doesn't seem the most secure/ auditable way of tracking authorisation.

 

[Ish]

Thanks. I will take a look at that. It is not a critical process.