How to Dock Windows in Excel Visual Basic Editor

Save

Excel is a spreadsheet program included in the Microsoft Office suite of productivity software. It is commonly available on PCs and Macs. A spreadsheet manages data through a series of tables with individual data points placed in table cells. Excel allows Visual Basic (VBA) to write scripts to provide special functionality in Excel. Sometimes when writing these scripts, it would be convenient to 'dock' these windows to free up space on your screen.

Things You'll Need

  • Microsoft Excel with VBA
  • Open Excel and then open VBA. The shortcut to opening VBA is "ALT+F11."

  • Select the "Tools" menu then select "Options."

  • In the dialog box, click on the "Docking" tab. Make sure all the boxes are check on this tab, then click "OK."

  • The toolbar windows can be docked simply by moving them towards a side of the window pane. The code windows can be docked by double clicking on the header or clicking on the "Maximize" button in the upper right corner. The code windows are undocked by selecting the greyed "Restore Window" button in the upper right corner. Code windows can be alternated between by using "CTRL+Tab."

Tips & Warnings

  • This was tested with VBA in Microsoft Excel 2007. It should work with other versions, though the location of the options may be different.

References

Promoted By Zergnet

Comments

You May Also Like

  • How to Edit Data in Microsoft Excel

    Microsoft Excel is the most frequently used spreadsheet software. You can use Microsoft Excel for making lists, keeping track of your addresses...

  • How to Edit Programs in Visual Basic

    Once a computer program is installed and used, it sometimes requires updating due to output errors or changes in user requirements. An...

  • How to Make Text Bold in GIMP

    GIMP is a freeware graphics application that many people who cannot afford Photoshop use to create graphics and documents for things like...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!