I have a regular sub where the user is given the option to save; if they
enter a filename, then I want Excel to go to a specific tab and copy the
values from one range and paste to another range (same tab) prior to the
save. Excel gets over to the before save sub in ThisWorkbook okay, but it
does none of the events in the before save sub. I've put in breakpoints, and
when stepping through, it just goes through the lines of code in the before
save sub, but doesn't actually act on any of them, like it went into a coma.
I'm at my wits end as to why this is happening; have tried everything I can
think of, but still it does not work. Enable events is on. Can someone
enlighten me PLEASE???