'How to make custom ribbon on existing workbook using VBA and without downloading other software?
Problem:
I would like to be able to edit the ribbon on a single workbook and place my own tabs and macros within the custom ribbon. Obviously I don't these tabs to show on other workbooks etc (there are few rules, see below section)...
Rules
Ideally I want to be able to do it without downloading anything. My work place is crazy strict with downloading from the outside world. (but I might be able to do it fromm home if its the best way).
I need to be able to do it on an existing workbook, there are just to many graphs/formatting/data/macros within the workbook to move everything over to a new workbook.
Ideally it needs to be a very repeatable/Safe/Reliable method, this workbook is a massive work in progress so I will probably be coming back to it and adding more tabs/macros as the months go by.
Previous attempts
I have tried working with the custom UI briefly in the past. People suggested things like downloading the custom UI editor? I think that I managed to sort of start editing an existing sheet that had the custom UI within it already. But I could not figure out how to increment this into an existing workbook very easily.
FYI I am very familiar with VBA but not HTML...
Can anyone give me a few quick steps that I need to do or is there some documentation out there? I did try looking but couldn't find anything....
Cheers
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
