You would need VBA event code to add the filldown command to right-click.

How about just go to ToolsCustomizeCommandsEdit and drag the FillDown button
to a toolbar?

For the event code................

Sub fill()
Selection.FillDown
End Sub

Sub fill() goes into a general module.

The following two events go into the Thisworkbook module.

I suggest you open a new workbook, copy the macro and event code into that
workbook then Save As an Add-in which loads when Excel starts.

If you go that route, you don't really need the BeforeClose event.

Sub Workbook_Open()
With Application.CommandBars("Cell").Controls.Add(tempo rary:=True)
.BeginGroup = True
.Caption = "Fill Down"
.OnAction = "Fill"
End With
End Sub

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


Gord Dibben MS Excel MVP


On Wed, 20 Jun 2007 07:33:01 -0700, JimC wrote:

Is there a way in Excel to add options to the right click functions for the
mouse. For example, I would like to be able to use the fill down function by
right clicking instead of using CTRL D on the keyboard.