Ribbon problem with "OnLoad"

mcsuman

New Member
Joined
Jul 3, 2017
Messages
14
Office Version
  1. 365
Platform
  1. Windows
I do not understand.

I've got a workbook with a custom ribbon with a custom tab and two groups. The first group has three buttons and the second has three menus.

This workbook seems to work perfectly.

I changed the tags on the first three buttons with new ones (using Office RibbonX Editor).

I've got a second workbook that is identical to the first except that the original tags have been replaced everywhere with the new ones.

Now this workbook cannot execute "RibbonOnLoad" when it is opened.

I do not understand. How can this be?
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Can you post the Ribbon XML and the VBA call back that is not working?

I will try to reproduce the error.
 
Upvote 0
I don't know how to post the excel workbook.

Here the VBA code:

Option Explicit


Dim Rib As IRibbonUI
Public MyTag As String

'Callback for customUI.onLoad
Sub RibbonOnLoad(ribbon As IRibbonUI)
Set Rib = ribbon
'If you want to run a macro below when you open the workbook
'you can call the macro like this :
Call EnableControlsWithCertainTag3
End Sub

Sub GetEnabledMacro(control As IRibbonControl, ByRef Enabled)
If MyTag = "Enable" Then
Enabled = True
Else
If control.Tag Like MyTag Then
Enabled = True
Else
Enabled = False
End If
End If
End Sub

Sub RefreshRibbon(Tag As String)
MyTag = Tag
If Rib Is Nothing Then
MsgBox "Error, Save/Restart your workbook" & vbNewLine & _
"Visit this page for a solution: http://www.rondebruin.nl/ribbonstate.htm"
Else
Rib.Invalidate
End If
End Sub

'Note: Do not change the code above

Sub EnableControlsWithCertainTag1()
'Enable only the controls with a Tag that start with "G1"
Call RefreshRibbon(Tag:="G1*")
End Sub

Sub EnableControlsWithCertainTag2()
'Enable only the controls with a Tag that start with "Group2"
Call RefreshRibbon(Tag:="Group2*")
End Sub

Sub EnableControlsWithCertainTag3()
'Enable only the control with this Tag "Group1Button1"
Call RefreshRibbon(Tag:="G1B1")
End Sub

Sub EnableControlsWithCertainTag4()
'Enable only the controls with this Tag "Group?Button1"
'Note: you see that I use ? this can be any character (group 1 or 2 in this example)
'This example will enable the first button now in each group
Call RefreshRibbon(Tag:="Group?Button1")
End Sub


Sub EnabledAllControls()
'Enable all controls
Call RefreshRibbon(Tag:="*")
End Sub

Sub DisableAllControls()
'Disable all controls
Call RefreshRibbon(Tag:="")
End Sub

Here are the callbacks:

'Callback for customUI.onLoad
Sub RibbonOnLoad(ribbon As IRibbonUI)
End Sub

'Callback for G1B1 onAction
Sub Macro1(control As IRibbonControl)
End Sub

'Callback for G1B1 getEnabled
Sub GetEnabledMacro(control As IRibbonControl, ByRef returnedVal)
End Sub

'Callback for G1B2 onAction
Sub Macro2(control As IRibbonControl)
End Sub

'Callback for G1B3 onAction
Sub Macro3(control As IRibbonControl)
End Sub

'Callback for G2M1U1 onAction
Sub Macro4(control As IRibbonControl)
End Sub

'Callback for G2M1U2 onAction
Sub Macro5(control As IRibbonControl)
End Sub

'Callback for G3M1U3 onAction
Sub Macro6(control As IRibbonControl)
End Sub

'Callback for G2M2R1 onAction
Sub Macro7(control As IRibbonControl)
End Sub

'Callback for G2M2R2 onAction
Sub Macro8(control As IRibbonControl)
End Sub

'Callback for G2M2R3 onAction
Sub Macro9(control As IRibbonControl)
End Sub

'Callback for G2M3O1 onAction
Sub Macro10(control As IRibbonControl)
End Sub

'Callback for G2M3O2 onAction
Sub Macro11(control As IRibbonControl)
End Sub

'Callback for G2M3O3 onAction
Sub Macro12(control As IRibbonControl)
End Sub
'Callback for customUI.onLoad
Sub RibbonOnLoad(ribbon As IRibbonUI)
End Sub

'Callback for G1B1 onAction
Sub Macro1(control As IRibbonControl)
End Sub

'Callback for G1B1 getEnabled
Sub GetEnabledMacro(control As IRibbonControl, ByRef returnedVal)
End Sub

'Callback for G1B2 onAction
Sub Macro2(control As IRibbonControl)
End Sub

'Callback for G1B3 onAction
Sub Macro3(control As IRibbonControl)
End Sub

'Callback for G2M1U1 onAction
Sub Macro4(control As IRibbonControl)
End Sub

'Callback for G2M1U2 onAction
Sub Macro5(control As IRibbonControl)
End Sub

'Callback for G3M1U3 onAction
Sub Macro6(control As IRibbonControl)
End Sub

'Callback for G2M2R1 onAction
Sub Macro7(control As IRibbonControl)
End Sub

'Callback for G2M2R2 onAction
Sub Macro8(control As IRibbonControl)
End Sub

'Callback for G2M2R3 onAction
Sub Macro9(control As IRibbonControl)
End Sub

'Callback for G2M3O1 onAction
Sub Macro10(control As IRibbonControl)
End Sub

'Callback for G2M3O2 onAction
Sub Macro11(control As IRibbonControl)
End Sub

'Callback for G2M3O3 onAction
Sub Macro12(control As IRibbonControl)
End Sub

Here is the XML:


<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI onLoad="RibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>

<tab idMso="TabHome" >

<group id="MyCustomGroup1" label="Auditor" tag="MyPersonalGroup1" >
<button id="G1B1" label="FindJrnls" size="normal" onAction="Macro1" tag="G1B1" getEnabled="GetEnabledMacro"/>
<button id="G1B2" label="InitJrnls" size="normal" onAction="Macro2" tag="G1B2" getEnabled="GetEnabledMacro"/>
<button id="G1B3" label="PostJrnls" size="normal" onAction="Macro3" tag="G1B3" getEnabled="GetEnabledMacro"/>
</group>
<group id="MyCustomGroup2" label="Actions" tag="MyPersonalGroup2" >
<menu id="G2M1" label="Utilities" >
<button id="G2M1U1" label="Button U1" onAction="Macro4" getEnabled="GetEnabledMacro"/>
<button id="G2M1U2" label="Button U2" onAction="Macro5" getEnabled="GetEnabledMacro"/>
<button id="G3M1U3" label="Button U3" onAction="Macro6" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M2" label="Reports" >
<button id="G2M2R1" label="Button R1" onAction="Macro7" getEnabled="GetEnabledMacro"/>
<button id="G2M2R2" label="Button R2" onAction="Macro8" getEnabled="GetEnabledMacro"/>
<button id="G2M2R3" label="Button R3" onAction="Macro9" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M3" label="Other" >
<button id="G2M3O1" label="Button O1" onAction="Macro10" getEnabled="GetEnabledMacro"/>
<button id="G2M3O2" label="Button O2" onAction="Macro11" getEnabled="GetEnabledMacro"/>
<button id="G2M3O3" label="Button O3" onAction="Macro12" getEnabled="GetEnabledMacro"/>
</menu>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
 
Upvote 0
Try this:

VBA Code:
Dim Rib As IRibbonUI
Public MyTag$

'Callback for customUI.onLoad
Sub RibbonOnLoad(ribbon As IRibbonUI)
Set Rib = ribbon
'If you want to run a macro below when you open the workbook
'you can call the macro like this :
EnableControlsWithCertainTag3
End Sub
'Callback for customUI.onLoad

Sub GetEnabledMacro(control As IRibbonControl, ByRef Enabled)
If MyTag = "Enable" Then
Enabled = True
Else
If control.Tag Like MyTag Then
Enabled = True
Else
Enabled = False
End If
End If
End Sub
'Callback for G1B1 getEnabled

Sub RefreshRibbon(Tag As String)
MyTag = Tag
If Rib Is Nothing Then
MsgBox "Error, Save/Restart your workbook" & vbNewLine & _
"Visit this page for a solution: http://www.rondebruin.nl/ribbonstate.htm"
Else
Rib.Invalidate
End If
End Sub

'Note: Do not change the code above

Sub EnableControlsWithCertainTag1()
'Enable only the controls with a Tag that start with "G1"
Call RefreshRibbon(Tag:="G1*")
End Sub

Sub EnableControlsWithCertainTag2()
'Enable only the controls with a Tag that start with "Group2"
Call RefreshRibbon(Tag:="Group2*")
End Sub

Sub EnableControlsWithCertainTag3()
'Enable only the control with this Tag "Group1Button1"
Call RefreshRibbon(Tag:="G1B1")
End Sub

Sub EnableControlsWithCertainTag4()
'Enable only the controls with this Tag "Group?Button1"
'Note: you see that I use ? this can be any character (group 1 or 2 in this example)
'This example will enable the first button now in each group
Call RefreshRibbon(Tag:="Group?Button1")
End Sub

Sub EnabledAllControls()
'Enable all controls
Call RefreshRibbon(Tag:="*")
End Sub

Sub DisableAllControls()
'Disable all controls
Call RefreshRibbon(Tag:="")
End Sub

'Callback for G1B1 onAction
Sub Macro1(control As IRibbonControl)
MsgBox "Macro1"
End Sub

'Callback for G1B1 onAction

'Callback for G1B2 onAction
Sub Macro2(control As IRibbonControl)
End Sub

'Callback for G1B3 onAction
Sub Macro3(control As IRibbonControl)
End Sub

'Callback for G2M1U1 onAction
Sub Macro4(control As IRibbonControl)
End Sub

'Callback for G2M1U2 onAction
Sub Macro5(control As IRibbonControl)
End Sub
'Callback for G3M1U3 onAction
Sub Macro6(control As IRibbonControl)
End Sub
'Callback for G2M2R1 onAction
Sub Macro7(control As IRibbonControl)
End Sub
'Callback for G2M2R2 onAction
Sub Macro8(control As IRibbonControl)
End Sub
'Callback for G2M2R3 onAction
Sub Macro9(control As IRibbonControl)
End Sub
'Callback for G2M3O1 onAction
Sub Macro10(control As IRibbonControl)
End Sub
'Callback for G2M3O2 onAction
Sub Macro11(control As IRibbonControl)
End Sub
'Callback for G2M3O3 onAction
Sub Macro12(control As IRibbonControl)
End Sub
'**********

Rich (BB code):
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI onLoad="RibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon>
<tabs>
<tab idMso="TabHome" >
<group id="MyCustomGroup1" label="Auditor" tag="MyPersonalGroup1" >
<button id="G1B1" label="FindJrnls" size="normal" onAction="Macro1" tag="G1B1" getEnabled="GetEnabledMacro"/>
<button id="G1B2" label="InitJrnls" size="normal" onAction="Macro2" tag="G1B2" getEnabled="GetEnabledMacro"/>
<button id="G1B3" label="PostJrnls" size="normal" onAction="Macro3" tag="G1B3" getEnabled="GetEnabledMacro"/>
</group>
<group id="MyCustomGroup2" label="Actions" tag="MyPersonalGroup2" >
<menu id="G2M1" label="Utilities" >
<button id="G2M1U1" label="Button U1" onAction="Macro4" getEnabled="GetEnabledMacro"/>
<button id="G2M1U2" label="Button U2" onAction="Macro5" getEnabled="GetEnabledMacro"/>
<button id="G3M1U3" label="Button U3" onAction="Macro6" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M2" label="Reports" >
<button id="G2M2R1" label="Button R1" onAction="Macro7" getEnabled="GetEnabledMacro"/>
<button id="G2M2R2" label="Button R2" onAction="Macro8" getEnabled="GetEnabledMacro"/>
<button id="G2M2R3" label="Button R3" onAction="Macro9" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M3" label="Other" >
<button id="G2M3O1" label="Button O1" onAction="Macro10" getEnabled="GetEnabledMacro"/>
<button id="G2M3O2" label="Button O2" onAction="Macro11" getEnabled="GetEnabledMacro"/>
<button id="G2M3O3" label="Button O3" onAction="Macro12" getEnabled="GetEnabledMacro"/>
</menu>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
 
Upvote 0
Try this:

VBA Code:
Dim Rib As IRibbonUI
Public MyTag$

'Callback for customUI.onLoad
Sub RibbonOnLoad(ribbon As IRibbonUI)
Set Rib = ribbon
'If you want to run a macro below when you open the workbook
'you can call the macro like this :
EnableControlsWithCertainTag3
End Sub
'Callback for customUI.onLoad

Sub GetEnabledMacro(control As IRibbonControl, ByRef Enabled)
If MyTag = "Enable" Then
Enabled = True
Else
If control.Tag Like MyTag Then
Enabled = True
Else
Enabled = False
End If
End If
End Sub
'Callback for G1B1 getEnabled

Sub RefreshRibbon(Tag As String)
MyTag = Tag
If Rib Is Nothing Then
MsgBox "Error, Save/Restart your workbook" & vbNewLine & _
"Visit this page for a solution: http://www.rondebruin.nl/ribbonstate.htm"
Else
Rib.Invalidate
End If
End Sub

'Note: Do not change the code above

Sub EnableControlsWithCertainTag1()
'Enable only the controls with a Tag that start with "G1"
Call RefreshRibbon(Tag:="G1*")
End Sub

Sub EnableControlsWithCertainTag2()
'Enable only the controls with a Tag that start with "Group2"
Call RefreshRibbon(Tag:="Group2*")
End Sub

Sub EnableControlsWithCertainTag3()
'Enable only the control with this Tag "Group1Button1"
Call RefreshRibbon(Tag:="G1B1")
End Sub

Sub EnableControlsWithCertainTag4()
'Enable only the controls with this Tag "Group?Button1"
'Note: you see that I use ? this can be any character (group 1 or 2 in this example)
'This example will enable the first button now in each group
Call RefreshRibbon(Tag:="Group?Button1")
End Sub

Sub EnabledAllControls()
'Enable all controls
Call RefreshRibbon(Tag:="*")
End Sub

Sub DisableAllControls()
'Disable all controls
Call RefreshRibbon(Tag:="")
End Sub

'Callback for G1B1 onAction
Sub Macro1(control As IRibbonControl)
MsgBox "Macro1"
End Sub

'Callback for G1B1 onAction

'Callback for G1B2 onAction
Sub Macro2(control As IRibbonControl)
End Sub

'Callback for G1B3 onAction
Sub Macro3(control As IRibbonControl)
End Sub

'Callback for G2M1U1 onAction
Sub Macro4(control As IRibbonControl)
End Sub

'Callback for G2M1U2 onAction
Sub Macro5(control As IRibbonControl)
End Sub
'Callback for G3M1U3 onAction
Sub Macro6(control As IRibbonControl)
End Sub
'Callback for G2M2R1 onAction
Sub Macro7(control As IRibbonControl)
End Sub
'Callback for G2M2R2 onAction
Sub Macro8(control As IRibbonControl)
End Sub
'Callback for G2M2R3 onAction
Sub Macro9(control As IRibbonControl)
End Sub
'Callback for G2M3O1 onAction
Sub Macro10(control As IRibbonControl)
End Sub
'Callback for G2M3O2 onAction
Sub Macro11(control As IRibbonControl)
End Sub
'Callback for G2M3O3 onAction
Sub Macro12(control As IRibbonControl)
End Sub
'**********

Rich (BB code):
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI onLoad="RibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon>
<tabs>
<tab idMso="TabHome" >
<group id="MyCustomGroup1" label="Auditor" tag="MyPersonalGroup1" >
<button id="G1B1" label="FindJrnls" size="normal" onAction="Macro1" tag="G1B1" getEnabled="GetEnabledMacro"/>
<button id="G1B2" label="InitJrnls" size="normal" onAction="Macro2" tag="G1B2" getEnabled="GetEnabledMacro"/>
<button id="G1B3" label="PostJrnls" size="normal" onAction="Macro3" tag="G1B3" getEnabled="GetEnabledMacro"/>
</group>
<group id="MyCustomGroup2" label="Actions" tag="MyPersonalGroup2" >
<menu id="G2M1" label="Utilities" >
<button id="G2M1U1" label="Button U1" onAction="Macro4" getEnabled="GetEnabledMacro"/>
<button id="G2M1U2" label="Button U2" onAction="Macro5" getEnabled="GetEnabledMacro"/>
<button id="G3M1U3" label="Button U3" onAction="Macro6" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M2" label="Reports" >
<button id="G2M2R1" label="Button R1" onAction="Macro7" getEnabled="GetEnabledMacro"/>
<button id="G2M2R2" label="Button R2" onAction="Macro8" getEnabled="GetEnabledMacro"/>
<button id="G2M2R3" label="Button R3" onAction="Macro9" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M3" label="Other" >
<button id="G2M3O1" label="Button O1" onAction="Macro10" getEnabled="GetEnabledMacro"/>
<button id="G2M3O2" label="Button O2" onAction="Macro11" getEnabled="GetEnabledMacro"/>
<button id="G2M3O3" label="Button O3" onAction="Macro12" getEnabled="GetEnabledMacro"/>
</menu>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
 
Upvote 0
I made your change, but still can't OnLoad macro to run...? Did it run for you?
 
Upvote 0
Yes. Here is my workbook:

ribbon_jul.xlsm

Well, now I am really confused. Your workbook (ribbon_jul.xlsm) works. Mine, which seems to be identical in the ribbon code does not.

I took your code, opened the XML, and added Tags for the menu buttons, and added the appropriate callback code. After this your code cannot be run. Now getting "Cannot run onLoad macro".

Here's the XML I changed:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI onLoad="RibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2006/01/customui">

<!-- Add two custom groups on the Home Tab with a few buttons -->

<ribbon>
<tabs>

<tab idMso="TabHome" >

<group id="MyCustomGroup1" label="Auditor" tag="MyPersonalGroup1" >
<button id="G1B1" label="FindJrnls" size="normal" onAction="Macro1" tag="G1B1" getEnabled="GetEnabledMacro"/>
<button id="G1B2" label="InitJrnls" size="normal" onAction="Macro2" tag="G1B2" getEnabled="GetEnabledMacro"/>
<button id="G1B3" label="PostJrnls" size="normal" onAction="Macro3" tag="G1B3" getEnabled="GetEnabledMacro"/>
</group>

<group id="MyCustomGroup2" label="Actions" tag="MyPersonalGroup2" >
<menu id="G2M1" label="Utilities" >
<button id="G2M1U1" label="Button U1" onAction="Macro4" tag="G2M1U1" getEnabled="GetEnabledMacro"/>
<button id="G2M1U2" label="Button U2" onAction="Macro5" tag="G2M1U2" getEnabled="GetEnabledMacro"/>
<button id="G3M1U3" label="Button U3" onAction="Macro6" tag="G2M1U3" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M2" label="Reports" >
<button id="G2M2R1" label="Button R1" onAction="Macro7" tag="G2M2R1" getEnabled="GetEnabledMacro"/>
<button id="G2M2R2" label="Button R2" onAction="Macro8" tag="G2M2R2" getEnabled="GetEnabledMacro"/>
<button id="G2M2R3" label="Button R3" onAction="Macro9" tag="G2M2R3" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M3" label="Other" >
<button id="G2M3O1" label="Button O1" onAction="Macro10" tag="G2M3O1" getEnabled="GetEnabledMacro"/>
<button id="G2M3O2" label="Button O2" onAction="Macro11" tag="G2M3O2" getEnabled="GetEnabledMacro"/>
<button id="G2M3O3" label="Button O3" onAction="Macro12" tag="G2M3O3" getEnabled="GetEnabledMacro"/>
</menu>
</group>

</tab>

</tabs>
</ribbon>
</customUI>
 
Upvote 0
Note that my schema address is different. Also, you cannot have two VBA macros with the same name.

If it still does not work, post a link to your workbook.
 
Upvote 0
Well, now I am really confused. Your workbook (ribbon_jul.xlsm) works. Mine, which seems to be identical in the ribbon code does not.

I took your code, opened the XML, and added Tags for the menu buttons, and added the appropriate callback code. After this your code cannot be run. Now getting "Cannot run onLoad macro".

Here's the XML I changed:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI onLoad="RibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2006/01/customui">

<!-- Add two custom groups on the Home Tab with a few buttons -->

<ribbon>
<tabs>

<tab idMso="TabHome" >

<group id="MyCustomGroup1" label="Auditor" tag="MyPersonalGroup1" >
<button id="G1B1" label="FindJrnls" size="normal" onAction="Macro1" tag="G1B1" getEnabled="GetEnabledMacro"/>
<button id="G1B2" label="InitJrnls" size="normal" onAction="Macro2" tag="G1B2" getEnabled="GetEnabledMacro"/>
<button id="G1B3" label="PostJrnls" size="normal" onAction="Macro3" tag="G1B3" getEnabled="GetEnabledMacro"/>
</group>

<group id="MyCustomGroup2" label="Actions" tag="MyPersonalGroup2" >
<menu id="G2M1" label="Utilities" >
<button id="G2M1U1" label="Button U1" onAction="Macro4" tag="G2M1U1" getEnabled="GetEnabledMacro"/>
<button id="G2M1U2" label="Button U2" onAction="Macro5" tag="G2M1U2" getEnabled="GetEnabledMacro"/>
<button id="G3M1U3" label="Button U3" onAction="Macro6" tag="G2M1U3" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M2" label="Reports" >
<button id="G2M2R1" label="Button R1" onAction="Macro7" tag="G2M2R1" getEnabled="GetEnabledMacro"/>
<button id="G2M2R2" label="Button R2" onAction="Macro8" tag="G2M2R2" getEnabled="GetEnabledMacro"/>
<button id="G2M2R3" label="Button R3" onAction="Macro9" tag="G2M2R3" getEnabled="GetEnabledMacro"/>
</menu>
<menu id="G2M3" label="Other" >
<button id="G2M3O1" label="Button O1" onAction="Macro10" tag="G2M3O1" getEnabled="GetEnabledMacro"/>
<button id="G2M3O2" label="Button O2" onAction="Macro11" tag="G2M3O2" getEnabled="GetEnabledMacro"/>
<button id="G2M3O3" label="Button O3" onAction="Macro12" tag="G2M3O3" getEnabled="GetEnabledMacro"/>
</menu>
</group>

</tab>

</tabs>
</ribbon>
</customUI>
Note that my schema address is different. Also, you cannot have two VBA macros with the same name.

If it still does not work, post a link to your workbook.

I really appreciate your help, but I'm feeling kind of stupid:
1. I cannot get access to the schema you cite, and it is not provided in Ofice RibbonX Editor.
2. I can't find anyplace where I have two VBA macros with the same name.
3. I do not know how to "post a link" to my workbook.
 
Upvote 0

Forum statistics

Threads
1,212,931
Messages
6,110,745
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top