Forum Discussion
Solved
Customized Ribbons, Macros, & Copying Files
I run a small business with a big honkin' spreadsheet with a dozen or so worksheets inside. To facilitate the operations with this spreadsheet, I've created a couple dozen macros to navigate within ...
- You can export your customisations to a file, edit that file in a text editor and after that re-import the file:
- Open Excel
- Right-click ribbon and click "Customize the Ribbon..."
- Click the "Import/Export" button
- Choose "Export All Customizations"
- Save to a location of your liking
- Close Excel
- Find that file
- Edit a copy of the file just created (use Notepad), changing the location of your macros (look for items starting with "onAction=")
- Save file
- Open Excel
- Right-click ribbon and click "Customize the Ribbon..."
- Click the "Import/Export" button
- Choose "Import Customization File"
- Select the edited file
MSFT have considered an option to take care of this: adding ribbon customizations to files. So rather than having to update your general ribbon customizations (which is what the above process does), you avoid all this hassle by adding the customisations to the file in question. Those customizations then only appear when you open that file.
That would work for me. To me, it's inconsistent to associate macros to a file and not the customization.
I think it should be an option -- sometimes, I might want some customization to be available for all spreadsheets, but in the case of my small business spreadsheet, I'd want the customization to be associated with the file (so that it gets copied when the file gets copied).
- Well, there you go, but the only way to do so is by using the methods described on Ron de Bruin's website.