Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-13-2012, 09:12 AM
hanvyj hanvyj is offline How to make an add-in/global macro Windows XP How to make an add-in/global macro Office 2003
Advanced Beginner
How to make an add-in/global macro
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default

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 :|
Reply With Quote
 

Tags
addin, macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make an add-in/global macro 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
How to make an add-in/global macro Global template ryalls3857 Word 1 12-27-2010 05:45 PM
How to make an add-in/global macro 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft