Aight, I'm not exactly a programmer but I know how to do enough things in VB to be pretty dangerous to myself. I have a spreadsheet that is tracking some very expensive things, and it's constantly being updated by 3 or 4 different people. I've got the code in so that the last author and last save time are being displayed for me, but I'd like to have a macro that will run and update these 2 cells whenever I (or anyone else) saves the document.

Is this possible? If so, how must it be coded to get it to work?

I figured out a work around that does what i need. Mods can close this down.

Do a barrel roll.

If multiple people are accessing this and it's constantly being updated I'm wondering why you're using Excel and not Access or some online database program.

I was told to do it in excel.