Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Persistent Excel toolbar
I used the code below to add a toolbar to my excel 97
Set xlapp = CreateObject("Excel.Application") xlapp.visible=true Set xlbook = xlapp.Workbooks.add 'xlapp.volatile(false) Set cbs = xlapp.CommandBars Set cb = cbs.Add("Impression CAB", 1,,false) cb.Visible = True Set cbc = cb.Controls.Add(1) cbc.OnAction = "'c:\ged\perso.xls'!ImprimeCAB" cbc.Caption = "Imprimer CAB" cbc.FaceId = 59 xlbook.saved=true xlapp.Quit the prolem is that the toolbar is not added permanentely to my excel help plz. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel ODBC driver created table/data not persistent | Excel Discussion (Misc queries) | |||
excel toolbar like word toolbar, please | Excel Discussion (Misc queries) | |||
Persistent External File Links | Setting up and Configuration of Excel | |||
How to Delete a persistent Toolbar? | Excel Discussion (Misc queries) | |||
saving toolbar buttons on custom toolbar | Excel Programming |