View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
singincpa[_2_] singincpa[_2_] is offline
external usenet poster
 
Posts: 1
Default adding shortcut menu items


The macro that I am using to add items is:

Sub AddItemToShortcut()
' Adds specified function to shortcut menu
'
Set NewItem = CommandBars("Cell").Controls.Add
With NewItem
.Caption = "Paste Values"
.OnAction = "PasteValues"
.BeginGroup = False
End With
End Sub

What should it be? Thank

--
singincp
-----------------------------------------------------------------------
singincpa's Profile: http://www.excelforum.com/member.php...fo&userid=1587
View this thread: http://www.excelforum.com/showthread.php?threadid=27361