Set the VBA IDE Options
 
 
 

You can change the characteristics of the VBA IDE using the Options dialog box. To open the Options dialog box, use the Tools menu and select Options.

The Options dialog box contains four tabs: Editor, Editor Format, General, and Docking.