Call a custom ribbon toggle button macro from a different workbook?

aquixano · Nov 17, 2018

Note: This is a cross-posted issue from another forum from August that is not yet resolved. Here is the link to that post. https://www.excelforum.com/excel-pr...in-from-a-different-workbook.html#post5011188

I have a custom ribbon toggle button for enabling/disabling Events I created in an .xlam file for a custom ribbon tab which gives me a visual reminder whether Events are on or not. I want to be able to call that macro from other workbooks. Originally I was getting a run-time error that the macro wasn’t available, however through subsequent research I was able to resolve that issue with this code which I customized from another source using this call code:

Code:

      strProcessName = "'" & "C:\Users\Trader\AppData\Roaming\Microsoft\AddIns\Ribbon Trading Tab.xlam" & " '" & "!" & "Macro1" 
      varTest = Application.Run(strProcessName)

Now I’m getting a “Run-time error '449': Argument not optional” message. I’m unsure what Argument it needs or the syntax it needs to be in. This is the custom ribbon code from the .xlam file which I’m trying to run - which I customized from Ron de Bruin’s website.

Code:

  'Callback for customToggleButton1 onAction
  Sub Macro1(control As IRibbonControl, pressed As Boolean)
      myRibbon.InvalidateControl ("customToggleButton1")
          Select Case Application.EnableEvents
          Case True
              Application.EnableEvents = False
   
               PressedState = True
          Case False
              Application.EnableEvents = True
   
               PressedState = True
          End Select
      myRibbon.InvalidateControl ("customToggleButton1")
  End Sub

I’ve had great support from the other website, although from my experience there aren’t as many experts relative to customizing the ribbon. So I’m posting this question here to hopefully catch some new eyes that belong to others with relevant experience customizing the ribbon.

Does anyone know what Argument I need to add? I appreciate any assistance – Thanks for reading.

James006 · Nov 17, 2018

Hello,

Andy Pope is one of the best worldwide gurus ... !!!

aquixano · Nov 17, 2018

That’s what I understand & I had already downloaded and tried to install his Ribbon Editor, but I’ve been unable to get it to work on my computer. I have Excel 2010 and when I try and launch it I get an error message that “Could not load some objects because they are not available on this machine.”

His editor requires 6 references to work, but I was only able to find exact matches for three of them. The other three I selected the closest item I could find. Below on the left is what Andy said was required and on the right is what I had available.

Microsoft Excel 12.0 Object Library --------------Microsoft Excel 14.0 Object Library

OLE Automation Microsoft Office 12.0------------OLE Automation

Object Library Microsoft Forms 2.0---------------Microsoft Forms 2.0 Object Library

Do you know if the Libraries on the right have replaced those on the left or where I could get those Libraries on the left if not?

Thanks.

Call a custom ribbon toggle button macro from a different workbook?

aquixano

New Member

Excel Facts

James006

Well-known Member

aquixano

New Member

Similar threads

Forum statistics

Share this page

Call a custom ribbon toggle button macro from a different workbook?

aquixano

New Member

Excel Facts

James006

Well-known Member

aquixano

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock