Hi all,
I have created a custom toolbar on which i have created some macro
buttons they all work fine except the last one, when the workbook is
opened which is stored on a network the last custom button "Area
Leaders" does not appear and causes a runtime error 5, the button only
appears when the workbook is opened on the machine it was created on!

Hope you can help,
Simon.
P.S below is my auto open code

Sub Auto_open()
Dim msgentry As String
ActiveSheet.Protect
With Application
CommandBars("Reviewing").Visible = False
CommandBars.ActiveMenuBar.Enabled = False
CommandBars("Formatting").Visible = False
CommandBars("Standard").Visible = False
CommandBars("matrix").Visible = True
CommandBars("Menu1").Visible = True
CommandBars("matrix").Controls("Date view").OnAction =
"dateview"
CommandBars("matrix").Controls("skill view").OnAction =
"skillview"
CommandBars("matrix").Controls("update current").OnAction =
"enter"
CommandBars("matrix").Controls("view lock").OnAction =
"viewlock"
CommandBars("matrix").Controls("autofilter toggle").OnAction =
"autofiltertoggle"
CommandBars("matrix").Controls("administration").O nAction =
"admin"
CommandBars("matrix").Controls("Deactivate/Activate").OnAction
= "enevents"
CommandBars("matrix").Controls("Area Leaders").OnAction =
"ALbutt"
DisplayFullScreen = False
DisplayFormulaBar = False
DisplayStatusBar = False

End With

msgentry = "Welcome to Plant Matrix" & vbCrLf & _
"Any Problems or Queries, Contact Training Department"
MsgBox msgentry, vbOKOnly, "Plant Matrix"

End Sub


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=501430