Copy/Paste doesn't trigger macro
I have a macro that is executed automatically when certain
values change in memory.
These values in memory are derived from cell values which
are read by udf's.
The macro sets the scales and other properties of scatter
charts in the workbook. I have inserted a Debug.Print
instruction for the purpose of testing.
I have also used the Code Cleaner add-in.
Everything is fine when I fill the cells manually, or when I
delete them, or when I copy/paste from an external program
(like notepad). Fine too when I mark and copy text in a cell
and then paste it in the appropriate cell.
But when I copy/paste from within Excel (either from
adjacent cells or from another workbook, and either with
Paste or with Paste Special / Values), the macro code isn't
executed. A Beep instruction inserted in the Change
Properties module isn't executed either.
Can anything be done about this ?
Thanks
|