Save Automatic

[Abhijeet]

Hi

I want enter any value in excel then automatic save that file
Please give me macro for this

 

[sgmpatnaik]

@Abhijeet

please try this code in your workbook Module when ever you change in your any worksheet then the workbook will save

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    ActiveWorkbook.Save
End Sub

Hope it clear your problem other wise please give some more details

Thanks

 

[Smallman]

Abhijeet

Your question lacks a bit of clarity. Where do you want to enter the information? Is this in a range of cells, in a particular cell.

Thanks

Smallman

 

[Abhijeet]

Any cell of the workbook

 

[sgmpatnaik]

@Abhijeet

did you try that code which was given by me

 

[Luke M]

Just curious, why do you want this? This is going to cause a significant slow-down in how fast you can enter data, and also remove the ability to "undo" any mistakes.

 

[sgmpatnaik]

@Luke

yes you are correct

 

[SirJB7]

@Luke M
Hi!
Maybe the OP wants to get sure to don't lose any entered data ever again, what he might not know is the cost to be paid. Let him give a try (aka wait & see, I'd bet on no more than 10 minutes of use with this method).
Regards!

 

[Faseeh]

Hi Abhijeet,

You can adjust the time set for saving the workbook, if you are interested in avoiding data loss....