Saving on cell value change

[MikeFranz123]

Hi,

I'm trying to save the active workbook whenever a cell is changed. I've found a few different ways of doing it online, but none of them seem to be working for me. Here is an example:

Please Login or Register  to view this content.

The guys on the forum said it was working, but for some reason I can't get it to run. It seems at though it doesn't even enter the code at all, because I put a break point right at the beginning and nothing happened.

Another example I found was:

Please Login or Register  to view this content.

But again, it doesn't seem at though VBA ever tries to execute this code.

Any help would be greatly appreciated!

Thanks

Mike

[katiespirations]

second code is working
check this code maybe is in a module instead of in the worksheet code, and try

[MikeFranz123]

Excellent! You're right, it was in a module, not in the worksheet object itself.

Thanks for the help!

Mike