![]() |
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. |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com