Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
modification to suit Excel 2000
I have created procedures which run properly on Excel
2002. I need to run them on Excel 2000 but I do not have access to this older version any more. Could you please have a look on the code below and let me know what I should change to have it running error free ? 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, temporary:=True) cb.Style = msoButtonCaption cb.Caption = "Calculate Totals" cb.OnAction = "Template.xls! ThisWorkbook.CalculateTotals" End If End Sub Thanks for help. Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shorttcut key for entering suit symbols in Microsoft Excel | Excel Discussion (Misc queries) | |||
Prevent Cell modification when Excel is executed | Excel Discussion (Misc queries) | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
VBA Excel 2000 - one shot multiple cells modification | Excel Programming |