I want to be able to put my own custom icons in Excel. The code below works nicely, but instead of FaceID, I want to replace it with my own icon or image.
Can someone help me with this problem.
Public The_Menu As CommandBar
Function CreateSubMenu() As CommandBar
Const pop_up_menu_name =...
For several years I have used the following code to disable/enable commandbar controls, but since updating to Excel 2016 for Mac it no longer works:
' Controls the enabling/disabling of all controls with the specified Id.
Private Sub EnableControl(pintCtrlId As Integer, pbooEnable As Boolean)...
I am building a custom menu in VBA. This process pulls data from a SQL DB, which takes some time and a connection for each item in the menu. Now I need to have this same menu on each open Excel workbook so the user has access to it no matter which workbook they are on. The more workbooks that...
I have a bit of code that will work when launching via the ribbon (or from VB), but not will not work when launched via a shortcut key.
The activate tab box will pop up when launched via the shortcut key, but it won't go to the tab selected.
This is for the box that pops up when there are more...
How do i customize the particular menu which comes when you right-click on the Ribbon in Excel ? It has options like:
"Add to Quick Access Toolbar"
"Customize Quick Access Toolbar"
I have code to customize the normal context menus in Excel 2010 using...
Using Excel 2013 (32bit) to build an add-in for my workplace. Done lots of this sort of thing before but new to Excel 2013.
I have a userform with several controls on it, one of which is a TreeView. This TreeView control is used to display and interact with structured data from a...
I am using following 2 lines of code in a subroutine, which creates a pivot table:
Application.CommandBars("PivotTable").Visible = False
ActiveWorkbook.ShowPivotTableFieldList = False
After these lines of code have run, both the command bar and the Field List are still visible, but...
While working on a macro I had to made my File menu invisible by Application.CommandBars("File").Visible = False. After completing my task I made my File Menu again vishible by making the same condition True.
However, in the process I have lost my access Key (Alt +F). Now I don't see...
Hello Excel Experts!
I have filled a custom CommandBar in Excel 2007 with like 10 control elements. However, these controls are positioned in a single row by Excel on CommandBar creation.
Is there a way to wrap the line of controls at determined positions? I have tried the .Width property of...
I have an issue with a command bar whose buttons shall work only when a certain workbook is active; this also when it has changed name due to an 'Save as...' operation. For that to work, a global variable needs to be updated every time when the workbook changes name.