problem with toolbar?

  • Thread starter Thread starter pgoodale
  • Start date Start date
P

pgoodale

Hi,
I have a very large spreadsheet which is used by many people. I have
been updating this spreadsheet so that it is more effecient, so far
successfully. I have just created a new toolbar which has on it,
buttons which I created which link to macro's. The problem I have is
that everything looks great on my pc, however when another person looks
at the spreadsheet, it is updated with everything except the new
toolbar. I have saved it correctly and the other people are opening the
correct file. Anyone have any thoughts which would help?????????
 
You have to copy the Excel.xlb file to each computer using the workbook.
That contains the new/altered toolbars.
Jim
 
or use some code to generate the toolbar with the workbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Jim said:
You have to copy the Excel.xlb file to each computer using the workbook.
That contains the new/altered toolbars.
Jim
Click to expand...
 
Jim,

This a reprint of a previous post on this topic

Just put a call to this proc in the Workbook_Open event in ThisWorkbook.

Public Sub CreateCommandBar()
Dim oCB As CommandBar
Dim objButton As CommandBarButton

On Error Resume Next 'just in case
Application.CommandBars("Todd's toolbar").Delete

On Error GoTo 0

With Application
Set oCB = .CommandBars.Add("Todd's toolbar", msoBarTop, , True)
With oCB

Set objButton = .Controls.Add(msoControlButton, , , , True)
With objButton
.Caption = "Test Toolbar"
.Tag = "Personal button"
.TooltipText = "An example of tooltip text"
.Style = msoButtonIconAndCaption
.OnAction = "Todd's macro"

End With

End With

oCB.Visible = True

End With

End Sub


If you intend to add lots of buttons, it is probably best to create a table
driven commandbar builder. I have a simple example if you want it.

By the way, you can add icons to the button s. John Walkenbach has a nice
utility to help you pick the id at
http://j-walk.com/ss/excel/tips/tip67.htm

--


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top