excel vba option dialog box
 

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

excel vba option dialog box
 

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

"joost" wrote:

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

excel vba option dialog box
 

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

"joost" wrote:

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