Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2000
    Location
    Temple, Texas, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    E-mail workbook with custom toolbar (Excel 2000 SR-1)

    Once again I've searched Excel help and MSKB with no luck. I have a workbook in which I've created a custom toolbar and macros. I attached the toolbar using the Toolbars |Customize |Attach command and saved the file. When I e-mailed the file as an attachment via Outlook, the custom toolbar didn't go with the file. Am I misunderstanding the Attach command? What should I do or not do or do differently? Thanks a lot.
    Jim Whitt
    Pharmacist
    Temple, Texas

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E-mail workbook with custom toolbar (Excel 2000 SR-1)

    The custom tool bars are not kept in the .xls file, they are kept in a .xlb file. however, if you mail your .xlb file to someone else, the customizations you made will overide any customizations that the person receiving the file has made to their system. You would also need an install procedure to replace their .xlb file with yours.

    What is usually a better idea is to use the workbook open event routine to create the customizations and then remove them in the workbook close event routine so you leave the other user's system the way it was.
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Dec 2000
    Location
    Temple, Texas, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E-mail workbook with custom toolbar (Excel 2000 SR-1)

    Thanks very much, Legare.
    Jim Whitt
    Pharmacist
    Temple, Texas

Posting Permissions

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