Export Editor Format?

Hello,

For sure you do know these settings are stored at the Application level ...

So basically, once you have modified them, your Excel application will apply them for each and every new workbook ...

Do not know how familiar you are with Excel ...

But ... the only path is I can think of is for you to dive into VBIDE ... to program VBA ...

You would need to search into the following library :

Microsoft Visual Basic For Applications Extensibility 5.3

Hope this will help

Why do change it? Most users, myself included, simply use the default.

Hi Wilker,

Thanks for your Thanks

What you are telling me is a confirmation of what I had anticipated ...

Indeed, Developers did not bother to dig that deep

They're all stored in the registry (there's more than one key for the various options you can set). The exact location will change depending on the version of Office (and therefore VBA) that you have, but it will be something like:

HKEY_CURRENT_USER\Software\Microsoft\VBA\7.1\Common

and you can export that as a .reg file, copy it to the new machine (assuming the same version) and then just double-click to install to the registry.

Hi Wilker,

For working with the Registry with VBA-friendly functions ... Chip had an excellent summary :

http://www.cpearson.com/excel/registry.htm

Hope this will help