Save

[bcr]

I need some code that will save when a new row is activiated. can someone please help me out. or to where it saves every minute, without having to make it a shared workbook.

[royUK]

In the WorkBook_Open event place this code

Please Login or Register  to view this content.

In a Standard module use this

Please Login or Register  to view this content.

[boylejob]

Roy,

I want to be sure I understand what this code is doing.

This is activated when the work book opens and causes the file saving code fire every 5 seconds.

Please Login or Register  to view this content.

This bit of code actually saves the file and gives a save message

Please Login or Register  to view this content.

This bit updates the time so the next save will occur 5 seconds afer the new time.

Please Login or Register  to view this content.

Is my thinking correct?

[royUK]

Hi Jeff

That's about right, I forgot to delete the messagebox because it isn't necessary. I will edit & make the times 1 minute.