excel vba option dialog box

[joost]

Hello,

How can you hide the option dialog box in Excel (2003) (Tools - Option).
Which VBA code can be used or is this possible through protection.

Thanks

Groet
Joost

 

[Guest]

Try this and don't forget you must enable it before closing:-

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

Mike

 

[Guest]

Ah you wanted to hide it , not disable it. It's nearly the same just set the
visible property to false.