ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Persistent Excel toolbar (https://www.excelbanter.com/excel-programming/278489-persistent-excel-toolbar.html)

Mohamed ABOU-ZAID

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