Try this, the first 3 lines turn standard menubars off, the 4th you nee
to insert your menu bar name and the next 2 lines (which you can repeat
are to assign subs to buttons when the workbook is opened (modify wit
your names).

Hope this helps

Simon

Sub Auto_open()

With Application
.CommandBars.ActiveMenuBar.Enabled = False
.CommandBars("Formatting").Visible = False
.CommandBars("Standard").Visible = False
.CommandBars("your menubar name").Visible = True
.CommandBars("your menubar name").Controls("your butto
name").OnAction = "your sub name"
.CommandBars("your menubar name").Controls("your butto
name").OnAction = "your sub name"
.DisplayFullScreen = False
.DisplayFormulaBar = False
.DisplayStatusBar = False
End With
End Su

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27141