Excel: Cannot Access Workbook Table of Contents with Keyboard

 Last reviewed: July 16, 1997
Article ID: Q87541

The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0

SUMMARY

In version 4.0 of Microsoft Excel, you cannot directly activate the table of contents of an open workbook by using the keyboard. This functionality is only accessible when you are using a mouse.

WORKAROUND

Assigning a macro containing the function WORKBOOK.ACTIVATE to a hot key enables you to activate the table of contents of an open workbook using the keyboard. This macro may be written or recorded, using the Macro Recorder.

The ALT+PAGEUP and ALT+PAGEDOWN key combinations can be used to move forward and backward through the documents of a workbook. You can page through the documents until you reach the Table of Contents, but there is no key combination to activate the Table of Contents directly.

REFERENCES

"User's Guide 1," version 4.0, pages 67-78

Additional query words: 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: July 16, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.