![]() |
#2
|
|||
|
|||
![]()
I think I've worked out why Its not working.
It calls ActiveSheet, which is referring to the "CopyPasteFormula.xlsm" sheet, not the one where you are pressing the copy button... I need to somehow work out how to find out sheet that was active before Still don't know why it opens it as an addon every time though :| |
Tags |
addin, macro |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
glnz | Word VBA | 8 | 09-07-2022 02:09 PM |
Are changes to the ribbon global? | TechEd | Word | 0 | 05-26-2011 12:23 AM |
![]() |
ryalls3857 | Word | 1 | 12-27-2010 05:45 PM |
![]() |
mkoenig | Word VBA | 1 | 01-31-2010 02:47 AM |
how to make global changes in existing doc? | hamster | Word | 0 | 03-18-2009 08:39 AM |