Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to restore VBA Editor to its initial settings?

Tags:

excel

vba

vbe

How to restore the VBA Editor to its intial settings ? I have some troubles with macro and projects explorer windows settings, after some bad manipulations.

like image 225
Stefyu Thechosenone Avatar asked Nov 07 '14 21:11

Stefyu Thechosenone


People also ask

How do I restore VBA in Excel?

Open the VBA editor (Alt+F11) Right-click on the module you want to recover and click 'Export File...'. Choose a location, type a name, and save your module. Repeat for all modules you will need.

What is reset in VBA?

The Reset statement closes all active files opened by the Open statement and writes the contents of all file buffers to disk.


1 Answers

I had the same problem and realised that if I double click the blue heading of a minimal floating menu, such as the Project-VBAProject menu, it would resize and fit in with the other menus that are expanded. With a bit of moving around and double clicking the headers of the menus that I had selected from the VIEW option, I could get the screen back to the way it originally looked at the default setting of the VBA editor.

Phil

like image 115
Phil Mustoe Avatar answered Sep 23 '22 09:09

Phil Mustoe