Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Waldorf, MD
    Posts
    18
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Excel 2003 Custom Toolbars

    After making changes to custom toolbars for Excel 2003, they do not appear when I run Excel again. I found two versions of Excel11.xlb in C:\Users\xxxx\AppData\Roaming\Microsoft\Excel and C:\Program Files (x86)\Microsoft Office\OFFICE11. Can anyone tell me why changes are lost? Thanks for any assistance.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 644 Times in 588 Posts

    Re-build the Excel11.xlb file

    Excel11.xlb is the Tool customization file that contain the modifications you make. Rename both files (Excel11.old) then restart Excel. The file will be rebuilt. If the CommandBars have not returned their previous state, then run the following codes depending on the condition. Delete the code then save the workbook with the default name given to it (usually Book1). Excel CommandBars should now fuction normally

    If your CommandBars are greyed-out, re-enable them with the following code:
    Code:
    Sub EnableCommandBars()
        Dim ComBar As CommandBar
        For Each ComBar In Application.CommandBars
            ComBar.Enabled =True
        Next
    End Sub
    If they are not visible, change the visible properties to tru using the following code:
    Code:
    Sub EnableCommandBars()
        Dim ComBar As CommandBar
        For Each ComBar In Application.CommandBars
            ComBar.Visible =True
        Next
    End Sub

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    bluegoose1776 (2013-03-15)

  4. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Waldorf, MD
    Posts
    18
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Maudibe, Thanks. My problem is not that the custom toolbars are not visible, but that changes in one session are not displayed in a subsequent session. Such as adding new buttons to a toolbar.

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 644 Times in 588 Posts
    BG,

    Go ahead and rename the files and let the Excel11.xlb rebuild the next time you open a workbook. Make the modifications then save. I was going on the premise that there might have been a problem with your customization and that starting clean might resolve your problem. I had placed the code there in case you had an unforseen problem of the commandbars not presenting correctly.

    Maud

  6. The Following User Says Thank You to Maudibe For This Useful Post:

    bluegoose1776 (2013-03-16)

Tags for this Thread

Posting Permissions

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