+ Reply to Thread
Results 1 to 3 of 3

Change assortment of border options

  1. #1
    Registered User
    Join Date
    12-02-2009
    Location
    New York State
    MS-Off Ver
    Excel 2003
    Posts
    47

    Change assortment of border options

    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.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Change assortment of border options

    You can't, unless you create your own toolbar and code behind it.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    12-02-2009
    Location
    New York State
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Change assortment of border options

    Quote Originally Posted by shg View Post
    You can't, unless you create your own toolbar and code behind it.
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1