+ Reply to Thread
Results 1 to 2 of 2

"Start a new group" coding possible for a commandbar (floating toolbar)?

  1. #1
    StargateFanFromWork
    Guest

    "Start a new group" coding possible for a commandbar (floating toolbar)?

    I have great workbooks now that I have a formula for for modifying whenever
    I need a commandbar. I'm able to fit these to any workbook, thanks to this
    group.

    The only thing I'm missing is to be able to put a vertical line like what
    one sees on a toolbar when we've chosen to "start a new group". Is there
    coding for a floating toolbar that will do the same thing?

    Thanks! :oD



  2. #2
    StargateFanFromWork
    Guest

    Re: "Start a new group" coding possible for a commandbar (floating toolbar)?

    Sorry, sorry!!! I forgot to check archives first (I sometimes forget, this
    is new impulse in last 6 months <g>). Found it in .BeginGroup = True). So
    here's what one the button's coding look like with new line re .BeginGroup
    separator:


    ****************************************************
    ' 6. Font down to size 9.
    Set myButton = .Controls.Add(Type:=msoControlButton, ID:=23)
    With myButton

    'this puts a separator
    .BeginGroup = True

    .Caption = "Font down to size 9."
    .Style = msoButtonIcon
    .FaceId = 79 'or use 366 for a sheet image
    .Enabled = True
    .OnAction = "FontToSize_09"
    End With
    ****************************************************

    Thanks! :oD



    "StargateFanFromWork" <NoSpam@NoJunkMail.com> wrote in message
    news:OUqyi%236kGHA.1640@TK2MSFTNGP02.phx.gbl...
    > I have great workbooks now that I have a formula for for modifying

    whenever
    > I need a commandbar. I'm able to fit these to any workbook, thanks to

    this
    > group.
    >
    > The only thing I'm missing is to be able to put a vertical line like what
    > one sees on a toolbar when we've chosen to "start a new group". Is there
    > coding for a floating toolbar that will do the same thing?
    >
    > Thanks! :oD




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1