I am using a brand new worksheet as an example. Please ensure that the Excel File is closed before you open it via CUIE. I create tabs for my Excel Applications/Add-Ins using this free utility called Custom UI Editor.Įdit: To accommodate new request by OP TutorialĪfter you have installed the Custom UI Editor (CUIE), open it and then click on File | Open and select the relevant Excel File. ![]() Additionally, the link that you mentioned above is for MS Project and not MS Excel. You can however hide/make visible a ribbon component using VBA. I tried this example from here but get an "object required" error on the last instruction : Public Sub AddHighlightRibbon()ĪFAIK you cannot use VBA Excel to create custom tab in the Excel ribbon. ![]() What is a quick and simple way to do that ? I'd like the new tab to get loaded when my VBA gets loaded into Excel. ![]() I chanced on some resources addressing it via Google but all look dodgy and outrageously complicated. I am looking for a way to add a custom tab in the Excel ribbon which would carry a few buttons.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |