| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
| Data Validation dialog box NO in-cell dropdown option | Excel Discussion (Misc queries) | |||
| In Excel Tools Menu Option Dialog box don't open | Excel Discussion (Misc queries) | |||
| Dialog box needs to pop up (Excel) | Excel Worksheet Functions | |||
Linear Mode
