adding to shortcut menus

[Stephen Simons]

is there a way to customise shortcut menus ??

I want to add a macro I created to the shortcut menu in XL.

Thanks

Steve

[David McRitchie]

Hi Stephen,
Is there a shortcut menu? How does one get the
shortcut menu and what do you want to see when you get there?

If you mean adding to a toolbar menu, or creating a toolbar
button, see
Toolbars, Custom Buttons and Menus
http://www.geocities.com/davemcritchie/excel/toolbars.htm
but they are not called shortcuts. You might also want to
look at the white and brighter yellow boxes on my Formulas page.
http://www.geocities.com/davemcritchie/excel/formula.htm

Shortcuts are keystroke combinations, see
http://www.geocities.com/davemcritchie/excel/shortx2k.htm

HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
Search Page: http://www.geocities.com/davemcritchie/excel/search.htm

"Stephen Simons" <sim...@pctamers.co.uk> wrote in message
news:3ad344f...@news.waitrose.com...

[Debra Dalgleish]

You can get info from this article on the MS Knowledge Base:

http://support.microsoft.com/support/kb/articles/Q166/7/55.asp

[Stephen Simons]

By shortcut menu I mean the one that appears when you right-click a
cell.

Steve

[David McRitchie]

Hi Steve,
Should have remembered that is what it is called, it is also interesting
that it is mentioned in the VBE Help and only in terms of spreadsheet
usage; whereas, the Excel help has nothing. Hope you found

"Stephen Simons" <sim...@pctamers.co.uk> wrote in message

news:3ad48fd2...@news.waitrose.com...

[Richard Price]

David

It's also interesting that you can customise them in Word exactly like
any other toolbar or menu: in the Customize dialogue there's an entry
for Shortcut Menus, which brings up a dummy menu bar with the Text,
Table and Draw menus on it. Nothing like that in Excel though - as
someone said here before, Microsoft's VP of User Interface Consistency
must have been out of the office that day. (Quite a few days,
actually.<g>)

Richard Price

"David McRitchie" <DMcRi...@msn.com> wrote in message
news:upr59HswAHA.1908@tkmsftngp03...

[Drew Paterson]

Courtesy of Chip Pearson

"I use the following code in my personal.xls file to add two items to the
right-click menu. The items execute macros named "CopyFormula" and
"PasteFormula".

With Application.CommandBars("Cell").Controls
With .Add
.Caption = "C&opy Formula"
.OnAction = ThisWorkbook.Name & "!CopyFormula"
.Tag = cControlTag
.BeginGroup = True
End With

With .Add
.Caption = "P&aste Formula"
.OnAction = ThisWorkbook.Name & "!PasteFormula"
.Tag = cControlTag
End With
End With"

HTH

Drew

"Richard Price" <rjp...@my-deja.com> wrote in message news:OpSDa83wAHA.1276@tkmsftngp03...

[David McRitchie]

For some reason I thought coding had to be run each time
Excel was run so added it to Auto_Open, and was surprised
to find twenty sets added to the RClick menu. The following
line will reset the RClick menu, and can be placed in front
of such coding if it gets rerun.

Application.CommandBars("Cell").Reset 'was not in 2001-04-13 reply

David McRitchie
____
"Drew Paterson" <dre...@paradise.net.nz> wrote
in message news:uiqh89AxAHA.1620@tkmsftngp05...
Courtesy of Chip Pearson

HTH

Drew

[Drew Paterson]

Right, David, I should have thought of that, having run into something similar myself when experimenting to get this sort of thing up and running.

Replace the line:
With .Add
to read
With .Add(temporary:=True)

and the addition should remove itself when Excel closes.

Drew

"David McRitchie" <DMcRi...@msn.com> wrote in message news:Oxc17qOyAHA.1804@tkmsftngp02...

> For some reason I thought coding had to be run each time

>> With .Add