I have a set of 6 short and simple macros. Here is one of them:
Controls placed on worksheets operate the macros perfectly, but controls placed on my custom ribbon (developed with CustomUI) give this error:
Please Login or Register to view this content.
Any theories?wrong number of arguments or invalid property assignment
Last edited by arlu1201; 08-29-2012 at 02:57 PM.
that's not the right procedure declaration for a ribbon callback. if you use the generate callbacks button in the customui editor you will see the correct declarations
---------- Post added at 12:57 PM ---------- Previous post was at 12:49 PM ----------
is how it should lookPlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Well, something has happened! I now get a different error message, which says "Cannot run the macro gotoLstClk()'. The macro may not be available in this workbook or all macros may be disabled".
Macros are enable, as I have signed the VBA with a user-created certificate. When I use the View > Macros > View Macros, I cannot see these macros.
is that actually a macro or is it code behind a command button on a sheet? the code should be in a normal module (not worksheet) and not be marked private
the routine will not show in the macros dialog because it takes an argument-if you need it there you'll need to keep it as a separate macro and call that from the ribbon callback
Last edited by JosephP; 08-30-2012 at 01:12 AM.
The macros are stored in a module, not a worksheet. The ribbon code in the CustomUI file relevant to that macro (and two similar navigation macros) looks like this:
HTML Code:
I have amended my macros so that they all look similar to this:
I have removed the 'Private' declaration. Should i make it a 'Public' declaration?Please Login or Register to view this content.
Last edited by Cutter; 08-30-2012 at 12:56 PM. Reason: Replaced Quote tags with Code tags
no it will be public by default unless you added option private module to the top of the module. you should not have parentheses on the end of the macro name in the onAction property in your XML.
Thanks! It now all works!
I told you I was rusty - plus there weren't any ribbons last time I was doing this.
Nevertheless, I think the ribbon system is good, and I used 'CustomUI Editor' to store the CustomUI and the icons, because these macros are only relevant to this individual file. I had previously made the ribbon by Excel's customization, but this meant the ribbon was available in all Excel files, even though it wasn't relevant.
BTW, I find the interface in 'CustomUI Editor' to be small and not easy to work with. So I actually prepared the code in Notepad++, and copied back and forth.
I think it is now time for me to investigate adding some more subtle stuff to the ribbon, including passing parameters.
you may prefer this to the customui editor: http://www.andypope.info/vba/ribboneditor_2010.htm
Brilliant! The Ribbon Editor add-in is superb!
@ neddyseagoon
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
This took me a while to work out, but I finally sussed out why my custom ribbon wasn't working:
The macros associated with each button in the custom ribbon must be linked to the ribbon in the VBE:
I don't believe you need to Generate Callbacks in the Custom UI Editor, but it can be helpful to do this to check you have linked the macros correctly in VBA.Please Login or Register to view this content.
A useful tip, you can mouse-scroll up/down while holding CTRL to change the zoom in the Custom UI Editor and make the code more readable without awkward line-wraps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks