Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Attaching a custom toolbar to a workbook! (Excel 2000>)

    Hi all,

    Could You please enlighten me concerning this feature!

    I created a custom toolbar in a blank workbook on my workstation. I used to Attach Toolbar dialog to attach this custom toolbar to a workbook I needed to email to a colleague. When they opened the WB, the toolbar was available...great, (to be expected!)
    However,
    Shortly after that I emailed a different workbook to the same colleague, and I noticed the custom toolbar was available in that WB too?

    What am i missing here? (must be something silly - <img src=/S/confused.gif border=0 alt=confused width=15 height=20>)
    Waht is the purpose behind attaching a toolbar, or is a custom toolbar just naturally available Excel on another PC once a WB containing an attached toolbar is opened on that workstation?

    Tx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Attaching a custom toolbar to a workbook! (Excel 2000>)

    See Jan Karel Pieterse's <!post=Distributing an Excel application with toolbars (5/95/97/2000/2002),200526>Distributing an Excel application with toolbars (5/95/97/2000/2002)<!/post>.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Attaching a custom toolbar to a workbook! (Excel 2000>)

    <hr>You can attach a toolbar to a workbook. When this workbook is loaded, XL checks if the toolbar is on the system. If not, it copies the toolbar from the workbook to the system.<hr>

    Am I correct in saying that once the TB is attached and the WB is emailed, a reference of that TB will now exist on the recipient of that emails PC and unless they delete that TB, it will be available in excel on their PC for all WB's?
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Attaching a custom toolbar to a workbook! (Excel 2000>)

    That is correct. Excel itself does not delete a custom toolbar when the workbook to which it is attached is closed, so if you don't want the toolbar to be available in all workbooks, you must take care to delete it in the BeforeClose event of the workbook.

    Deleting the toolbar when the workbook is closed has two purposes:
    - You ensure that the latest version is used.
    - You avoid the toolbar from being available when it is not needed.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Attaching a custom toolbar to a workbook! (Excel 2000>)

    Perfect...

    <img src=/S/yum.gif border=0 alt=yum width=15 height=15>... the sweet taste of knowledge...i'm learning soo much this morning! I have some time off from work today, so I hope you don't mind if I continue posting some more ideas, questions, tips...and getting your input on them!?

    BIG <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Attaching a custom toolbar to a workbook! (Excel 2000>)

    > I hope you don't mind if I continue posting some more ideas, questions, tips

    That's what the Lounge is for, isn't it? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Attaching a custom toolbar to a workbook! (Excel 2000>)

    Let me rephrase that a bit. If you want the toolbar to be only available to the workbook it belongs to, you need to:
    - remove the toolbar when that workbook closes
    - disable or hide the toolbar when that workbook looses the focus
    -Show the toolbar again when the workbook regains focus
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Attaching a custom toolbar to a workbook! (Excel 2000>)

    OK, that's better.

Posting Permissions

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