Persistent Excel toolbar

  • Thread starter Mohamed ABOU-ZAID
  • Start date
M

Mohamed ABOU-ZAID

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top