Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
psate values in right click
i would like to add paste value to the menu when you right click a cell to save time going to paste special -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=570634 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
psate values in right click
Hi Ceemo,
i would like to add paste value to the menu when you right click a cell to save time going to paste special Try: '============= Public Sub Tester() Dim iCtr As Long iCtr = Application.CommandBars("Cell"). _ FindControl(ID:=22).Index Application.CommandBars("Cell").Controls. _ Add Type:=msoControlButton, ID:=370, _ Befo=iCtr + 1 End Sub '<<============= --- Regards, Norman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
psate values in right click
thats exactly what i wanted many thanks !! Is there a way to apply this to every book i open without having to ad the code each time -- ceem ----------------------------------------------------------------------- ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065 View this thread: http://www.excelforum.com/showthread.php?threadid=57063 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
psate values in right click
in case it matters i run in excel 200 -- ceem ----------------------------------------------------------------------- ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065 View this thread: http://www.excelforum.com/showthread.php?threadid=57063 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
psate values in right click
Hi Ceemo,
Is there a way to apply this to every book i open without having to add the code each time? This is an application setting; the amended right-click menu will be avaialble to all open workbooks. --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a click on + symbol to open a root and click on -. | Excel Discussion (Misc queries) | |||
Disabling click and right-click on the Picture I inserted in an Excel document | Excel Worksheet Functions | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming | |||
Want to be able to click on a cell and have a list box appear to give values to populate a cell | Excel Programming |