Tuesday, March 19, 2013

How to Dock Windows in Excel Visual Basic Editor


1. Open Excel and then open VBA. The shortcut to opening VBA is 'ALT F11.'
2. Select the 'Tools' menu then select 'Options.'
3. In the dialog box, click on the 'Docking' tab. Make sure all the boxes are check on this tab, then click 'OK.'
4. 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.'

Blogger news