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
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.