Hi, I have made a program that uses macros to copy items from one sheet to another. Very simple really, but i can not link macros recorded in a xla file to buttons on my xls workbook. I have a custom toolbar and it calls macros from the same xla file fine, but when I click on a button on the workbook, that is supposed to run a macro, it tells me "the macro 'xxxx' can not be found" Why would the toolbar work and not a button on a sheet?
Last edited by jeeper74; 04-16-2009 at 05:56 PM. Reason: change in problem
Hello jeeper74,
How are you calling the xla macro in your code?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I think i have a workaround figured out... I can still use the macros through a userform, so I am trying to do that now.
I renamed my macro from endmht to blankpage, and i can now link to it. does the end in the name generate problems? or is this some unique case?
Is yout toolbaar attached to the addin?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks