Run Custom Ribbon Button without Macro Enable

[longtran295]

Dear all,
I use CustomUIEditor to create a buttons tab to open sheets (replace for default sheets tab), but I need active macro content to use buttons.

VBA in Modules>Module 1:

Sub opensheetA(control As IRibbonControl)
Sheets("A").Activate
End Sub

Custom Ribbon:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon>
<tabs>
<tab id="customTab" label="TestTab" insertBeforeMso="TabHome">
<group id="customGroup" label="TestGroup">
<button id="customButton" label="TestButton" siza="large" onAction="opensheetA" image="image1" />
</group>
</tab>
</tabs>
</ribbon>
</customUI>

So could I use custom ribbon buttons without macro enable?
Many thanks!

 

[RoryA]

Your question boils down to can you run code if code is disabled, so no.