|
There are three tabs in this
dialog.:.:
Toolbars
This is where you can select
toolbars to add to Excel, remembering that it
may not be necessary to add them as many are
'context sensitive', that is, they will appear
if you are taking actions that need that
toolbar, (e.g. Pivot Tables).
From here you can add
toolbars, via the 'New...' Button and name it in
the resultant dialog, thus:
Only 'added' toolbars can be
'renamed', 'Deleted' and 'Attached' to the
current workbook. Taking the 'Attach...' option
shows you all the 'custom' toolbars, like so:
(The bars are listed in 'Custom Toolbars',
selecting 'Copy>>', attaches them to the current
workbook).
This will allow you to add
'buttons' to the custom bar, as shown in the
section 'Commands' below.
Selecting any built-in
toolbar and selecting 'Reset...', will reset the
selected toolbar to it's default state, deleting
any user customisations.
Commands
Allows you to add buttons to menus or
toolbars. Excel ships with the common defaults,
but if, for example, you find yourself using
'Paste Special...>Values' a lot, you can add
this button to the toolbar of your choice, or a
custom one.
To add or remove a button
while the dialog is showing, simply drag the
command in the right window of the dialog, to or
from a toolbar and drop it.
With the dialog showing, with
a button selected on any toolbar, you can modify
several settings via the 'Modify Selection'
button as below.
Here the button is pressed,
while the 'Cut' button is selected on the
toolbar. You then get a myriad of options
to rename the button, change or edit the 'face'
image of the button, assign a hyperlink, macro,
etc. (The '&' before the 't' in cut,
signifies the underlined letter in the menu
option, which then becomes the 'access' key for
that menu option. So in this case, Alt+E will
get you the 'Edit' menu and Alt+t the 'Cut'
sub-menu.
Selecting 'Edit Button
Image...' shows the 'Button Editor' (as below),
which shows a 16pxl x 16pxl grid to change the
look of the button image.
The 'Rearrange Commands...'
button allows you to select the order for menu
and sub-menu options and toolbar buttons, (as
below). Example shows the 'File' menu, 'Send To'
sub-menu.
Again, you can add, delete,
modify selection and reset... from here also.
Options
Allows you to set the global
behaviour and 'look' of the toolbars. Including
the ability to switch off or reset the 'adaptive'
nature of the menu options.
 |
