 The
Tools menu offers all the customisation features for
Excel and non-Excel specific 'tools' such as spelling,
speech, AutoCorrect, etc. It also has tools for
some more general excel tasks such as macro recording,
workbook protection and sharing, add-ins, etc.
Generally you will also find that add-ins will quite
often add their menu options to the 'Tools' menu.The
reason most people return to this menu is to visit the
'Options...' selection, which carries all the Excel
specific customisations such as, number of worksheets in
a workbook, where files are saved as a default, whether
calculation is auto or manual, etc. It is one of
the most important areas of Excel, controlling so many
basic functions, but is also the area which generates
the most amount of user questions or misunderstanding.
As a rule in Office, (and most windows), programs, any
menu options with three ellipses (...) after the menu
option, will be followed by another dialog, any options
with a
►, will be followed by a sub-menu if
you hover over the
►.
The menu options on
the image to the left are live hyperlinks and will help
you navigate to the relevant page or you can use the
links on the far left.
In the linked pages you will find
detailed explanations of the option, together with a
code snippet on how the menu option may be implemented
in VBA (Visual Basic for Applications), any lines in
these snippets starting with a single apostrophe(') are comment lines to assist you
and explain what is being done and if pasted into
a module will appear green with no notice being taken of
them when the code is run. (To
implement and explain
VBA you would do best to read
the pages on this subject first).
Top |
