excel vba option dialog box

  • Thread starter Thread starter joost
  • Start date Start date
J

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
 
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
 
Ah you wanted to hide it , not disable it. It's nearly the same just set the
visible property to false.
 
Back
Top