How to AUTO SAVE with date stamp after every change but without confirmation

Well, that's pretty simply. You could had have found that by just a little search. Here's the code. Write this code in your ThisWorkbook. It'll never ask you for a save and it autosaves the changes at the exit. Just a heads up, it'll never ask you for a confirmation, so if anywhere data gets accidentally overwritten it'd be saved without asking you when it closes. Plus, you'll have to make sure that the file is first already saved in a particular location, if you'll be using this code to a newly opened workbook which is not yet saved.

Please Login or Register  to view this content.

I suggest, instead of this you could use a macro and assign it to a shape or an object. So just to make sure, it'd save the data only when this macro is called.

Please Login or Register  to view this content.

I need auto save not with button and your way doesnt work for me...
U can see my doc...

And i need to enter save path for new file

Hey.. I went through your document. But am not able to fully understand how you wish to update it. The sheet Prijava seems to store the timestamps per users (I think so). But how are they getting updated? Will you be able to guide me through the steps on how you update the timestamps in that sheet..

I have no idea about the other available sheets..

Plus, you said that you need to enter the save path for new file, where can I find that from..