Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RibbonX and a "macro may not be available" head-scratcher
So I have a simple .xlsm file with a couple very simple macros in it.
I've edited the customUI with the following code: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" <ribbon startFromScratch="true" <tabs <tab id="CustomTab" label="Trial Tab" <group id="SimpleControls" label="Trial Group" <button id="Button1" imageMso="HappyFace" size="large" label="Say Hi" onAction="sayHi3" / <button id="Button2" imageMso="HappyFace" size="large" label="ThisSayHi3" onAction="Thisworkbook.sayHi3" / </group </tab </tabs </ribbon </customUI When I open it, sure enough the tab is there with two buttons. When I hit the "Say hi" one I get the message: "Wrong number of arguments or invalid property assignment" which is reasonable I guess since I haven't qualified the macro name. Hitting the "ThisSayHi3" button gives the message "Cannot run the macro "Thisworkbook.sayHi3". The macro may not be avialable in this workbook or all macros may be disabled." This is more mysterious. The macro is there; macros are enabled; and it runs fine using F5 within the VB Editor. It's a just one-liner at this point invoking MsgBox(). I haven't found anything useful relating to this message on the Microsoft site, or MSDN, or (sigh) here. (The conditions mentiond in support.microsoft.com/kb/930076 article dosn't apply here.) So, while I suspect it's something blatantly obvious to others who know this RibbonX, it's baffling to me. Any hints out there about what's going on here? = Marchand = |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab? | Excel Programming | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
"Clean Me" Macro is giving "#VALUE!" error in the Notes field. | Excel Programming | |||
Sending macro based e-mail with built-in "Heading" and "Text" | Excel Programming |