+ Reply to Thread
Results 1 to 2 of 2

Right click menu

Hybrid View

  1. #1
    Darren
    Guest

    Right click menu

    Hi,

    is it possible to customise the right click menu, ie add or move items?

    Darren



  2. #2
    Bob Phillips
    Guest

    Re: Right click menu

    Public Sub addCellMenu()
    removeCellMenu 'just in case
    With Application.CommandBars("Cell")
    .Controls.Add(Type:=msoControlButton).Caption = "Routine1"
    .Controls.Add(Type:=msoControlButton).Caption = "Routine2"
    .Controls("Routine1").BeginGroup = True
    .Controls("Routine1").OnAction = "Another"
    .Controls("Routine2").OnAction = "YetMore"
    End With
    End Sub

    Public Sub removeCellMenu()
    On Error Resume Next
    With Application.CommandBars("Cell")
    .Controls("Routine1").Delete
    .Controls("Routine2").Delete
    End With
    On Error GoTo 0
    End Sub



    --
    HTH

    Bob Phillips

    "Darren" <darrenb.1@ntlworld.com> wrote in message
    news:OC4NZJmSFHA.3372@TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > is it possible to customise the right click menu, ie add or move items?
    >
    > Darren
    >
    >




+ 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