In the Commands list box, select "Custom Button"ĭrag this button to your new toolbar in the location where you want it to be. Scroll to the bottom of the Categories list. Toolbars can be attached to specific workbooks or addins but this is not discussed here. It is important to remember that a new toolbar is not workbook specific and will be available whenever Excel is open. This will then appear at the bottom of the list of toolbars in the (View > Customise) dialog box.Ī new empty (floating) toolbar will appear in your workbook. This will mean the toolbar is available for any new documents created by that template. If the current document is attached to a template other than Normal.dot you will be able to select this template using the drop-down list. You can only manipulate toolbars and menus while this dialog box is displayed.Īnother small dialog box will be displayed to allow you enter the name of your new toolbar.īy default the toolbar will be available to your Normal template unless the current document is another template or add-in, in which case it will default to that. (View > Customise)(Toolbars tab) dialog box Select (Tools > Customise) to display the Customise dialog box.Īnother quick way to display this dialog box is right mouse click on any toolbar and select "Customise" at the bottom.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |