|
|
#2
12-13-2012, 09:12 AM
|
|||
|
|||
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Need macro to make list of "defined terms"
|
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 |
|
Global template
|
ryalls3857 | Word | 1 | 12-27-2010 05:45 PM |
|
Can I automate or make a macro for this?
|
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 |
Windows XP 
Office 2003
Threaded Mode