Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Thanked 0 Times in 0 Posts

    MS Excel 2000 (Professional)

    How do you attach a custom toolbar to an Excel workbook so that when the workbook opens, the custom toolbar opens and appears on workbook? Thanks.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Reading/Swindon, Berkshire, United Kingdom
    Thanked 0 Times in 0 Posts

    Re: MS Excel 2000 (Professional)

    Right click on any toolbar area and select customise - it's down the bottom.

    Once you get the customise toolbar dialog up, select the toolbars tab and select attach. You should be able to run with it from there - a list of custom toolbars appears and you just select which ones you want.

    You may also want to consider creating them programatically with code - there's quite a few examples floating around but if you have problems finding them (searching the excel and vba forums with the word commandbar should be a good start) post back and we'll help you on your way.

Posting Permissions

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