Hi, just to add to what Ron and bob offered, this code hides just about
everything+ACE-


Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled +AD0- False
Next
With Application
.DisplayFormulaBar +AD0- False
.DisplayStatusBar +AD0- False
End With
With ActiveWindow
.DisplayHeadings +AD0- False
.DisplayWorkbookTabs +AD0- False
.DisplayHorizontalScrollbar +AD0- False
.DisplayVerticalScrollbar +AD0- False
End with

'this box just gives you a break to see your handiwork
MsgBox +ACI-No Bars, now get them back+ACI-
'the next bit reverses everything

For Each bar In Application.CommandBars
bar.Enabled +AD0- True
Next
With Application
.DisplayFormulaBar +AD0- True
.DisplayStatusBar +AD0- True
End With
With ActiveWindow
.DisplayHeadings +AD0- True
.DisplayWorkbookTabs +AD0- True
.DisplayHorizontalScrollbar +AD0- True
.DisplayVerticalScrollbar +AD0- True
End with

Cheers

Joe90

+ACI-devnext+ACI- +ADw-anonymous+AEA-discussions.microsoft.com+AD4- wrote in message
news:0c2601c39d54+ACQ-943f3590+ACQ-a401280a+AEA-phx.gbl...
hi,

how can i delete all toolbars and menus from my workbooks
when i start a certain excel application?

the objective is to the end user work only with the
controls that i've created.

thanks,