When I click for the dropdown menu of border options on my toolbar, I'm presented with an assortment of border options which doesn't terribly please me.
How does one alter the assortment of border options which is presented this way?
Thank you.
When I click for the dropdown menu of border options on my toolbar, I'm presented with an assortment of border options which doesn't terribly please me.
How does one alter the assortment of border options which is presented this way?
Thank you.
You can't, unless you create your own toolbar and code behind it.
Entia non sunt multiplicanda sine necessitate
Thanks,
I found in Excel Help how to create a toolbar. I'll paste the instructions below in case anyone else needs them. But when you say "code behind it", what do you mean?
Thanks
Create a custom toolbar
Show AllHide All
You can rearrange and change toolbar buttons, menus, and menu commands by using the mouse or you can use the Rearrange Commands dialog box, which you can access by using the keyboard. Tasks that you can accomplish by using the keyboard are identified as (keyboard accessible).
1.On the Tools menu, click Customize, and then click the Toolbars tab.
2.Click New.
3.In the Toolbar name box, type the name you want, and then click OK.
4.Click the Commands tab.
5.Do one of the following:
Add a button to the toolbar
Click a category in the Categories box.Drag the command you want from the Commands box to the displayed toolbar.
Add a button to the toolbar (keyboard accessible)
Click Rearrange Commands.Click Toolbar, and then click the new toolbar in the Toolbar list.Click Add.In the Categories list, click a category.In the Commands list, click the command you want.
Add a built-in menu to the toolbar
In the Categories box, click Built-in Menus.Drag the menu you want from the Commands box to the displayed toolbar.
Add a built-in menu to the toolbar (keyboard accessible)
Click Rearrange Commands.Click Toolbar, and then click the new toolbar in the Toolbar list.Click Add.In the Categories list, click Built-in Menus .In the Commands list, click the menu you want.
1.When you have added all the buttons and menus you want, click Close.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks