I have created a simple macro code and assigned a shortcut key from Macro option (ctrl+Z) and it worked like a charm but when I am using iRibboncontrol then Shortcut key not working. My code given below -
''''''''''
'In Previous code and shortcut key worked well
Sub HideAllExceptActiveSheet()...
Someone sent me a workbook to look at "because its no longer working". What they sent was an XLA file. They said it use to add a ribbon to their tool bar but now it doesn't work with the latest version of XLS.
Is this just missing a tool pack or Add-in that needs to be activated in her latest...
I have the following code which seemed to be working fine, and now all the sudden isn't working. It's a dropdown box built into the ribbon, and when selected, calls the following code:
Option ExplicitDim Rib As IRibbonUI
Private mwkbNavigation As Workbook
Sub getItemCount(control As...
Hi
I have a please wait message that appears if there is no other action in the sub but refuses to show if the sub calls another sub??
What's wrong with my code please
Public Sub MultipleProcessCheck_onAction(control As IRibbonControl)
' Button 53
' Please wait message...
I have an addin that uses SheetSelectionChange event to highlight the entire row and column in a sheet when I click on a cell. I would like the option to turn the highlighting on/off by selecting a checkbox. I added a checkbox by customizing the ribbon, and I have code that passes the value of...
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.