Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
customize right click
need help in customizing the right click context menu in excel, pls hel ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
customize right click
The third article is a detailed article on all aspects of working with
commandbars in Excel. The right click menu for a cell is Commandbars("Cell") http://support.microsoft.com/?id=159619 XL97: Sample Macros for Customizing Menus and Submenus http://support.microsoft.com/?id=213550 XL2000: Sample Macros for Customizing Menus and Submenus http://support.microsoft.com/default...b;en-us;166755 File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R) Excel 97 File Name: WE1183.EXE File Size: 58041 bytes File Date: 06/20/97 Keywords: kbfile kbappnote Description: This Application Note can help you learn techniques for writing Visual Basic(R) for Applications code to customize menus in Microsoft Excel 97. This Application Note contains code examples that you can use with the following elements: menu bars, menus, menu items, submenus, and shortcut menus. -- Regards, Tom Ogilvy "ksap" wrote in message ... need help in customizing the right click context menu in excel, pls help ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
customize right click
I like this one, which I use a fair bit:
Try putting this in Personal.xls, or an xla. add-in: Sub ValuesOnly() Application.ScreenUpdating = False On Error Resume Next If Application.CutCopyMode = False Then With Selection .Copy .PasteSpecial xlValues End With With Application .ScreenUpdating = True End With Else Selection.PasteSpecial xlValues End If Application.CutCopyMode = False End Sub Sub AddControl() With Application.CommandBars("Cell").Controls.Add(msoCo ntrolButton) .Caption = "Values" .FaceId = 1183 .OnAction = "ValuesOnly" End With End Sub Jason "Tom Ogilvy" wrote in message ... The third article is a detailed article on all aspects of working with commandbars in Excel. The right click menu for a cell is Commandbars("Cell") http://support.microsoft.com/?id=159619 XL97: Sample Macros for Customizing Menus and Submenus http://support.microsoft.com/?id=213550 XL2000: Sample Macros for Customizing Menus and Submenus http://support.microsoft.com/default...b;en-us;166755 File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R) Excel 97 File Name: WE1183.EXE File Size: 58041 bytes File Date: 06/20/97 Keywords: kbfile kbappnote Description: This Application Note can help you learn techniques for writing Visual Basic(R) for Applications code to customize menus in Microsoft Excel 97. This Application Note contains code examples that you can use with the following elements: menu bars, menus, menu items, submenus, and shortcut menus. -- Regards, Tom Ogilvy "ksap" wrote in message ... need help in customizing the right click context menu in excel, pls help ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i right click on file name and not get "customize ribbon" | Excel Discussion (Misc queries) | |||
Can I customize a right click to find data? | Excel Worksheet Functions | |||
Disabling click and right-click on the Picture I inserted in an Excel document | Excel Worksheet Functions | |||
disable customize option when right click on menu bar | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel |