problem with toolbar?

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?????????
 
J

Jim

You have to copy the Excel.xlb file to each computer using the workbook.
That contains the new/altered toolbars.
Jim
 
B

Bob Phillips

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...
 
B

Bob Phillips

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)
 
Top