Sorry I did not read your first posting as you said it was to complex, but
that told me the answer I was asking for, and Thanks it works just as I
hoped. Thanks again

"Mike" wrote:

The following code will disable the Tools - Options menu and can be put where
you want. One option is to put it in the workbook open event and have
corresponding code in the workbook before close event to re-enable the
controls.

Sub DeactivateIt()
With Application.CommandBars("Worksheet Menu Bar")
With .Controls("&Tools")
.Controls("&Options...").Enabled = False ' Change to true to
enable
End With
End With
End Sub

Mike

"gibsol" wrote:

I would like to hide the options box from view (tool/options), any ideas !!?.