+ Reply to Thread
Results 1 to 5 of 5

Right Click Fill Color

  1. #1
    Chipmunk
    Guest

    Right Click Fill Color

    Is it possible, to have a "right mouse click" option and it bring up in the
    menu various fill colors?

    What I need to happen, is throughout a spread sheet certain cells are
    changed often (only 1 of 3 colors) I understand that there is an option to
    select from multiple colors on the toolbar, but some sort of short cut would
    work better.

    Or even a spiral or dropdown in the cell to select a colors. Thanks.

  2. #2
    Jim Cone
    Guest

    Re: Right Click Fill Color

    C,
    That... "option to select from multiple colors on the toolbar"... can be
    displayed on your spreadsheet. Click the down arrow on the button
    and then at the very top center of the color palette, click and drag the
    palette onto the spreadsheet.
    Jim Cone
    San Francisco, USA


    "Chipmunk" <Chipmunk@discussions.microsoft.com>
    wrote in message
    news:CD893841-1272-459A-A721-3E86A05421BE@microsoft.com
    Is it possible, to have a "right mouse click" option and it bring up in the
    menu various fill colors?

    What I need to happen, is throughout a spread sheet certain cells are
    changed often (only 1 of 3 colors) I understand that there is an option to
    select from multiple colors on the toolbar, but some sort of short cut would
    work better.

    Or even a spiral or dropdown in the cell to select a colors. Thanks.

  3. #3
    Chipmunk
    Guest

    Re: Right Click Fill Color

    Not really what I was looking for. I was wanted something similiar to a
    right click & paste. Only, right click & red fill cell color.

    "Jim Cone" wrote:

    > C,
    > That... "option to select from multiple colors on the toolbar"... can be
    > displayed on your spreadsheet. Click the down arrow on the button
    > and then at the very top center of the color palette, click and drag the
    > palette onto the spreadsheet.
    > Jim Cone
    > San Francisco, USA
    >
    >
    > "Chipmunk" <Chipmunk@discussions.microsoft.com>
    > wrote in message
    > news:CD893841-1272-459A-A721-3E86A05421BE@microsoft.com
    > Is it possible, to have a "right mouse click" option and it bring up in the
    > menu various fill colors?
    >
    > What I need to happen, is throughout a spread sheet certain cells are
    > changed often (only 1 of 3 colors) I understand that there is an option to
    > select from multiple colors on the toolbar, but some sort of short cut would
    > work better.
    >
    > Or even a spiral or dropdown in the cell to select a colors. Thanks.
    >


  4. #4
    Jim Cone
    Guest

    Re: Right Click Fill Color

    C,
    The following code will add or remove the color palette on the
    cell right-click menu...
    '------------------------------
    Sub AddSomeColors()
    With Application.CommandBars("Cell")
    .Controls.Add ID:=1691, before:=1
    .Controls(2).BeginGroup = True
    End With
    End Sub

    Sub RemoveSomeColors()
    Application.CommandBars("Cell").Controls("Fill Color").Delete
    End Sub
    '---------------------------------
    Jim Cone
    San Francisco, USA


    "Chipmunk" <Chipmunk@discussions.microsoft.com>
    wrote in message
    news:F339B605-9B48-4381-91CF-25E69C303301@microsoft.com
    Not really what I was looking for. I was wanted something similiar to a
    right click & paste. Only, right click & red fill cell color.

    "Jim Cone" wrote:
    > C,
    > That... "option to select from multiple colors on the toolbar"... can be
    > displayed on your spreadsheet. Click the down arrow on the button
    > and then at the very top center of the color palette, click and drag the
    > palette onto the spreadsheet.
    > Jim Cone
    > San Francisco, USA


    >
    >
    > "Chipmunk" <Chipmunk@discussions.microsoft.com>
    > wrote in message
    > news:CD893841-1272-459A-A721-3E86A05421BE@microsoft.com
    > Is it possible, to have a "right mouse click" option and it bring up in the
    > menu various fill colors? >
    > What I need to happen, is throughout a spread sheet certain cells are
    > changed often (only 1 of 3 colors) I understand that there is an option to
    > select from multiple colors on the toolbar, but some sort of short cut would
    > work better. >
    > Or even a spiral or dropdown in the cell to select a colors. Thanks.



  5. #5
    Gord Dibben
    Guest

    Re: Right Click Fill Color

    And if you stick Jim's code in the Thisworkbook module they will run when you
    open the workbook and close it.

    Private Sub Workbook_Open()
    With Application.CommandBars("Cell")
    .Controls.Add ID:=1691, before:=1
    .Controls(2).BeginGroup = True
    End With
    End Sub

    Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.CommandBars("Cell").Controls("Fill Color").Delete
    End Sub


    Gord Dibben Excel MVP

    On Mon, 28 Nov 2005 12:23:16 -0800, "Jim Cone" <jim.coneXXX@rcn.comXXX> wrote:

    >C,
    >The following code will add or remove the color palette on the
    >cell right-click menu...
    >'------------------------------
    >Sub AddSomeColors()
    >With Application.CommandBars("Cell")
    > .Controls.Add ID:=1691, before:=1
    > .Controls(2).BeginGroup = True
    >End With
    >End Sub
    >
    >Sub RemoveSomeColors()
    >Application.CommandBars("Cell").Controls("Fill Color").Delete
    >End Sub
    >'---------------------------------
    >Jim Cone
    >San Francisco, USA
    >
    >
    >"Chipmunk" <Chipmunk@discussions.microsoft.com>
    >wrote in message
    >news:F339B605-9B48-4381-91CF-25E69C303301@microsoft.com
    >Not really what I was looking for. I was wanted something similiar to a
    >right click & paste. Only, right click & red fill cell color.
    >
    >"Jim Cone" wrote:
    >> C,
    >> That... "option to select from multiple colors on the toolbar"... can be
    >> displayed on your spreadsheet. Click the down arrow on the button
    >> and then at the very top center of the color palette, click and drag the
    >> palette onto the spreadsheet.
    >> Jim Cone
    >> San Francisco, USA

    >
    >>
    >>
    >> "Chipmunk" <Chipmunk@discussions.microsoft.com>
    >> wrote in message
    >> news:CD893841-1272-459A-A721-3E86A05421BE@microsoft.com
    >> Is it possible, to have a "right mouse click" option and it bring up in the
    >> menu various fill colors? >
    >> What I need to happen, is throughout a spread sheet certain cells are
    >> changed often (only 1 of 3 colors) I understand that there is an option to
    >> select from multiple colors on the toolbar, but some sort of short cut would
    >> work better. >
    >> Or even a spiral or dropdown in the cell to select a colors. Thanks.



+ 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