| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals
Private Sub Workbook_Open()
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = False End Sub Object variable or With Block not set Run-time error €˜91 Perplexed why this line works fine in an old project but not here. Correct object library is checked - looking into KB... Thanks, Arturo |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals
Do you use a English version ?
-- Regards Ron de Bruin http://www.rondebruin.nl "Arturo" wrote in message ... Private Sub Workbook_Open() CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = False End Sub Object variable or With Block not set Run-time error '91' Perplexed why this line works fine in an old project but not here. Correct object library is checked - looking into KB... Thanks, Arturo |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled =
Yes
2003 SP1 "Ron de Bruin" wrote: Do you use a English version ? -- Regards Ron de Bruin http://www.rondebruin.nl "Arturo" wrote in message ... Private Sub Workbook_Open() CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = False End Sub Object variable or With Block not set Run-time error '91' Perplexed why this line works fine in an old project but not here. Correct object library is checked - looking into KB... Thanks, Arturo |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled =
Use
Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = False -- Regards Ron de Bruin http://www.rondebruin.nl "Arturo" wrote in message ... Yes 2003 SP1 "Ron de Bruin" wrote: Do you use a English version ? -- Regards Ron de Bruin http://www.rondebruin.nl "Arturo" wrote in message ... Private Sub Workbook_Open() CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = False End Sub Object variable or With Block not set Run-time error '91' Perplexed why this line works fine in an old project but not here. Correct object library is checked - looking into KB... Thanks, Arturo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Can ActiveX controls be "disabled" and "enabled"? | Excel Programming | |||
| Can't Change Commandbars("Worksheet Menu Bar") | Excel Programming | |||
| CommandBars("Insert").Enabled question | Excel Programming | |||
Linear Mode
