Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clipboard Toolbar (Word 2000/SR-1)

    I like the Clipboard Toolbar and use it docked in Word with the other toolbars at the top of the screen. However, when it is visible and docked in Word and I switch to Outlook and open a message, the clipboard toolbar floats on top of the message. I can dock it, but it doesn't stay docked, so the next time I read a message it pops up again. Any solution?

  2. #2
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipboard Toolbar (Word 2000/SR-1)

    You'll probably have to use a macro to permanently dock the clipboard toolbar.

    The necessary property is the .Protected property of CommandBar objects.

    The help has an example macro that sets it to .Protection = msoBarNoChangeDock; you only need to change the name of the toolbar in that example from "Forms" to "Clipboard".
    Or if you want to nail it down permanently:
    CommandBars("Clipboard").Protection = msoBarNoMove.

    To set different kinfds of protection at the same time, you could add the msoBar constants:
    .Protection = msoBarNoCustomize + msoBarNoMove

    (this example doesn't apply to the Clipboard toolbar, because you can't customize that anyway)

    And if you want to remove the protection:
    CommandBars("Clipboard").Protection = msoBarNoProtection

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Klaus

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipboard Toolbar (Word 2000/SR-1)

    If you are not familiar with macros:
    You don't need to start writing them to run one-liners like this.

    Go to the VBA editor (Alt+F11), and in there to the Immediate window (Ctrl+G).
    Paste or type one of the one-liners
    <pre> CommandBars("Clipboard").Protection = msoBarNoChangeDock</pre>

    or
    <pre> CommandBars("Clipboard").Protection = msoBarProtectionMove</pre>

    or
    <pre> CommandBars("Clipboard").Protection = msoBarNoProtection</pre>

    and hit Return, then close the VBA editor.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Klaus

  4. #4
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipboard Toolbar (Word 2000/SR-1)

    The problem is that the clipboard in Word is carrying over to Outlook, but its docked status is not, so the clipboard always shows up on top of messages I want to read. I can dock it in Outlook, but it doesn't stay docked. The next time I open a message it is there again on top of the message text. I am NOT using Word as my editor for Outlook.

    These protection properties work in Word, but they do not have any effect on the clipboard that floats over Outlook messages when I view them. What does the "mso" prefix mean? It can't mean MS Outlook, because they don't affect Outlook.

    I can't get any of the examples about CommandBars to work in Outlook vb. There doesn't seem to be a CommandBars collection in Outlook.

  5. #5
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipboard Toolbar (Word 2000/SR-1)

    Found this in KB Q221190 "There is no VBA object model for the Office Clipboard, so there is no way to programmatically manipulate it". Looks like the protection property is only in Word VBA.

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Clipboard Toolbar (Word 2000/SR-1)

    <P ID="edit" class=small>(Edited by jscher2000 on 30-Aug-02 17:55. )</P><big>Edited: Earlier version should be ignored, sorry.</big>

    "There must be a way." <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    In Outlook messages, my clipboard toolbar always shows up, uninvited, on the row just below the menus, pushing down the other toolbars. I find that pretty annoying, but floating around would definitely be worse.

    In Outlook, there are two "mega-containers" that have their own CommandBars, the Explorer and the Inspector. To manipulate the toolbars that appear in a window displaying an open message, you use code like this:

    <pre>Sub LockClipBar()
    ' Locks the Office Clipboard toolbar to the right of the Formatting Toolbar
    Dim clipBar As CommandBar, fmtBar As CommandBar
    If Inspectors.Count = 0 Then Exit Sub
    Set clipBar = ActiveInspector.CommandBars("Clipboard")
    Set fmtBar = ActiveInspector.CommandBars("Formatting")
    With clipBar
    ' Make it stop floating around
    .Position = msoBarTop
    ' Position it to the right of the Formatting toolbar
    .RowIndex = fmtBar.RowIndex
    .Left = fmtBar.Width
    ' Lock in the position and prevent dragging off
    .Protection = msoBarNoProtection
    ' Make it visible (irrelevant if it already is)
    .Visible = True
    End With
    End Sub</pre>

    Hope this helps. But I notice the help for .Protection says "Returns or sets the way a command bar is protected from user customization." It may well be that Microsoft itself still will feel free to move it around! Anyway, I'll be pleased if, when it shows up, it's where I put it using the above code.

    P.S. This assumes you turn off that option to put your Standard and Formatting toolbars on the same row. If they are on the same row, this wouldn't be a very good way to position the clipboard toolbar!

  7. #7
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipboard Toolbar (Word 2000/SR-1)

    The info about inspectors and explorers helped a lot! Thanks! But your code doesn't solve the problem. It docks the clipboard toolbar, but it does not stay docked. It seems that every time I open something like a message, or I have a message shown and click "reply" or I start a new calendar appointment, everything starts over and the clipboard is back there floating on top of what I want to see instead of docked at the top. I will play with some of the other methods/properties and see if I can get something that "sticks".

    I have discovered something which confused the hell out of me and I want to pass along. In Outlook help, sometimes I get info from file outlhlp9.chm and sometimes I get help from file vbaoutl9.chm and sometimes from vbaoff9.chm. The way I discovered this was looking at the footer that I only get when I print from help. The info from vbaoff9 about command bars is not applicable to Outlook, and the code examples given result in a 13 or 424 error. I got extremely frustrated until I discovered by accident that Outlook help sometimes gives you general office vba help that is not correct for Outlook, and does not tell you!

  8. #8
    Lounger
    Join Date
    Aug 2002
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipboard Toolbar (Word 2000/SR-1)

    I am going to give up on this and just keep the clipboard closed in Word so it doesn't put itself in front of every email I open to read.

    I have discovered that when you open an email to read it, it is an "Inspector" as opposed to an "Explorer". I speculate that the ActiveInspector.CommandBars("Clipboard") code can only move the clipboard to the top on the particular message because the next message that is opened then becomes the ActiveInspector. I found some intriguing stuff in vbaoutl help about an event that fires whenever a new Inspector is created, but it looks like that is for using a Word macro to monitor Outlook events so I am not sure that an Outlook macro could use it. It seems that would work if somehow there could be some Outlook code that always moved the clipboard to the top whenever the new Inspector event fired. That is really out of my league. I do consider this a significant problem with the Office 2000 Office Clipboard that MS should provide a solution to.

Posting Permissions

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