Want custom toolbar to not be global
Want custom toolbar to not be global
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Want custom toolbar to not be global

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is it possible to attach a custom toolbar to a wb such that it is only visible and available when that wb is open?

    If not, can that scenario be created through other means?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    no replies, so I'll stick my oar in...

    is the workbook also limited to a certain group of users ?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Chris but I reposted earlier today and got an answer. It involved setting the "MyToolbar" visible attribute to false in the before close event.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was just about to suggest that...




    okie, important thing is you got it fixed.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Pilot

    Can i ask as you have a workable answer you post the feed thats answers thios so everyone can find the link (answer easy)

    You have reposted, rather than stick on this feed and return to the top of the board, some guys minght no see this answer

    Sure you understand... help others if you can mate!
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Good idea, Jack. Here's the boiled down version of the answer provided by TsTom and Mr Nick.

    This should work.
    Place it in your Workbook Deactivate and in the Close or before close:

    Application.CommandBars("Your CommandBar").visible = False

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com