Article ID: 118975
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 5.0c
- Microsoft Excel 5.0a for Macintosh
This article was previously published under Q118975
SYMPTOMS
In Microsoft Excel for the Macintosh, the key combinations CTRL+HOME and
CTRL+END do not move the selection to the top of the sheet, or to the end
of the sheet, respectively, when the active sheet is a Visual Basic module.
Additionally, when you press COMMAND+A, the sheet is not selected when the
active sheet is a Visual Basic module.
In Microsoft Excel for Windows, when you press CTRL+A, the sheet is not
selected when the active sheet is a Visual Basic module.
CAUSE
This behavior is by design in Microsoft Excel 5.0. The key combinations
COMMAND+A and CTRL+A are not supported in Visual Basic, Applications
Edition. These key combinations are supported when you are editing a
worksheet.
In Microsoft Excel for the Macintosh, when you press CTRL+HOME in a
worksheet, the selection moves to the top of the worksheet. When you press
CTRL+END in a worksheet, the selection moves to the end of the worksheet.
However, these keys do not work in a Visual Basic module in Microsoft Excel
for the Macintosh.
NOTE: The CTRL+HOME and CTRL+END key combinations are supported in a Visual
Basic module in Microsoft Excel 7.0.
WORKAROUND
To move the selection to the beginning of a Visual Basic module in
Microsoft Excel for the Macintosh, press COMMAND+HOME. To move the
selection to the end of a Visual Basic module, press COMMAND+END.
To select an entire module in Microsoft Excel, press CTRL+HOME, and then
press CTRL+SHIFT+END (Windows) or COMMAND+HOME and then press
COMMAND+SHIFT+END (Macintosh).
Additional query words: 5.00c keystrokes
Keywords: kbprb kbprogramming KB118975