Hi guys, I hope everything is going well with you.
Look, I need your help please.
Please check the attached.
I need to create Save event. So, once the sheet is saved, the file acts as follows:
- Type the date and time (NOW function) in the active row, second cell.
- Type the username (Environ username, I guess) in the active row, seventh cell.
- The last thing to auto-close the sheet once these commands are completed and the sheet is saved, however, and that’s the challenging thing that I’m not really sure if it’s doable, I want the sheet once it’s re-opened again, I need the lastly added row to be, editable yes, but not removable, like a footprint.
Could someone help with the code writing? I’m familiar with the needed functions for the first two points, yet, I’m not that good to write the code, and for point# 3, I don’t know at all how to do it or what to use.
Thank you guys.