Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Copy data into cells until changes trigger new copy | Excel Programming | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming |