Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Available options (2000 / 2003)

    Hi,

    I am having trouble finding out what options are available for the following code

    With CtrlPrintHandB
    .Title = "Print Header and plain"
    .Image = "????"
    .OnAction = "HeaderAndBlank"
    End With

    I am trying to add the Name when the mouse hovers over the button, set the button logo, set the OnAction to run another macro.

    Many thanks
    Regards
    Gerbil (AKA Kevin)

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

    Re: Available options (2000 / 2003)

    Type commandbarcontrol in the Visual Basic Editor and press F1.
    Click Properties in the help window.
    A list of available properties will drop down.
    When you click on a property, you'll get help for it.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Available options (2000 / 2003)

    Many thanks Hans
    Regards
    Gerbil (AKA Kevin)

  4. #4
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Available options (2000 / 2003)

    Hi,

    I'm still having trouble below is the code, I cant see whats wrong.

    With CtrlPrintHandB
    .Caption = "Print Header and plain"
    .FaceID = 0
    .OnAction = "HeaderAndBlank"
    End With

    Thanks
    Regards
    Gerbil (AKA Kevin)

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

    Re: Available options (2000 / 2003)

    FaceID = 0 will result in a blank button.

    If you want a button that displays its caption, use

    .Style = msoButtonCaption

    or if you want a picture and a caption, use

    .Style = msoButtonIconAndCaption

    but then you should set FaceID to something different from 0.

  6. #6
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Available options (2000 / 2003)

    Thank you Hans

    Got it now.

    Is the a directory of what each FaceID number is with a picture anywhere.
    Regards
    Gerbil (AKA Kevin)

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

    Re: Available options (2000 / 2003)

    Go to FaceID Browser and download the Word version (free).

  8. #8
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Available options (2000 / 2003)

    Thanks
    Regards
    Gerbil (AKA Kevin)

Posting Permissions

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