when you close excel and you have edited your VBA code it does not prompt you to save. i just wrote 300 lines of code and it did not get saved.
how do i force it to prompt when closing?
+1
A:
It should have prompted you to save. Check you have not set SetWarnings to off somewhere in your code
Kevin Ross
2010-07-23 07:25:12