Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How I can remove the custom command bar which I want to
add automaticaly when excel file is open. Adding is done by the following procedu Sub Workbook_Open() Dim c As CommandBar Dim cb As CommandBarButton Dim cp As CommandBarPopup On Error Resume Next Set c = Application.CommandBars("Worksheet Menu Bar") If Not c Is Nothing Then Set cb = c.Controls.Add(msoControlButton, 2) cb.Style = msoButtonCaption cb.Caption = "Calculate Totals" cb.OnAction = "Template 4.xls! ThisWorkbook.Calculate" End If End Sub Thanks for help. Regards, Tony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove Command Button After Click | Excel Discussion (Misc queries) | |||
How do you remove a macro command button? | Excel Discussion (Misc queries) | |||
How to remove all instances of a command button | Excel Discussion (Misc queries) | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |