Export VBA Editor Settings (VBE)

Question

I made changes to the VBA editor on my PC, including customizing toolbars. Is there a way to export them so that I can use them on another system without having to start from scratch?

Answer 1

See here:

How to restore the VBA editor to its original settings?

A different question, but there is an answer to your question.

Basically, you need to back up the key from the registry in the section: HKEY_CURRENTUSER\Software\Microsoft\VBA\6.0\Common

Edit:

Depending on your version of Office, you may need to use a slightly different key. For me it was: HKEY_CURRENTUSER\Software\Microsoft\VBA\7.1\Common

But it does work. Now, if the source and target machines have different versions of Office, this might be interesting. However, it is worth a try.