Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a simple addin to run a macro through a context menu.
It works fine in XL 2000 but does nothing in XL97. Even context menu command and icon is not created. Is there different syntext for XL2000 and XL97? Code as below. Regards, Shetty Code: In a module: Sub cmdadd() With CommandBars("Cell") With .Controls.Add .FaceId = 1183 .Caption = "Delete Star" .OnAction = "DeleteStar" End With End With end sub Sub DeleteStar() Selection.Replace "~*", "", xlPart, xlByRows, False End Sub In this workbook code panel: Private Sub Workbook_Open() Call cmdadd End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 working on files created with older versions | Excel Discussion (Misc queries) | |||
Linked spreadsheets created in 2003 but not working in 2007 | Excel Worksheet Functions | |||
XL2000 stock price web query stopped working | Excel Discussion (Misc queries) | |||
Function in xl2003 not working in xl97 | Excel Discussion (Misc queries) | |||
Workbooks.Open fails after upgrade to XL2000 from XL97 | Excel Programming |