Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteFace-Problem
Hi
I created an entry in the commandbar with a customized icon. The code is the following: Sub Test() Dim cbrMenuCtrl As CommandBarButton Worksheets("Init").Shapes(1).Copy Set cbrMenuCtrl = Application.CommandBars("Tools").Controls.Add With cbrMenuCtrl .Caption = "Hello" .OnAction = ThisWorkbook.Name & "!blabla" .PasteFace End With Application.CutCopyMode = False End Sub The problem is that the icon remains in the Excel memory. When I enter the paste command the icon will be pasted?!? How to free the memory? Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteFace-Problem
Sub Test()
Dim cbrMenuCtrl As CommandBarButton Worksheets("Init").Shapes(1).Copy Set cbrMenuCtrl = Application.CommandBars("Tools").Controls.Add With cbrMenuCtrl .Caption = "Hello" .OnAction = ThisWorkbook.Name & "!blabla" .PasteFace End With ActiveCell.Copy Application.CutCopyMode = False End Sub -- Regards, Tom Ogilvy "Tom" wrote in message ... Hi I created an entry in the commandbar with a customized icon. The code is the following: Sub Test() Dim cbrMenuCtrl As CommandBarButton Worksheets("Init").Shapes(1).Copy Set cbrMenuCtrl = Application.CommandBars("Tools").Controls.Add With cbrMenuCtrl .Caption = "Hello" .OnAction = ThisWorkbook.Name & "!blabla" .PasteFace End With Application.CutCopyMode = False End Sub The problem is that the icon remains in the Excel memory. When I enter the paste command the icon will be pasted?!? How to free the memory? Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |