Autosave after cell is modified

[sprucethebruce]

I've tried my usual google search and still at a loss, so.....

Mr Excel too the rescue, hopefully.

I want a spreadsheet to automatically save when any of the cells in the range P14:P95 are edited.

Anyone?

 

[sprucethebruce]

Sorry Nalani, you miss understood. I use the term shared as in multiple operators (machine operators), use it.

Its not used in an office environment and open by multiple computer users at one go.

I think shg's code works perfectly in this situation.

Thanks for your help though.

 

[Nalani]

Sorry Nalani, you miss understood. I use the term shared as in multiple operators (machine operators), use it.

Its not used in an office environment and open by multiple computer users at one go.

I think shg's code works perfectly in this situation.

Thanks for your help though.

No problem.

Sometimes the interpretation is not Clear.

At least you have a solution and a Workbook_BeforeClose Event to boot.

 

[jafarpp]

Here is the simple steps for the same: Auto Save Excel File After Cell Value Change