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

Do you use a English version ?

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Arturo" <[email protected]> wrote in message news:[email protected]...
> 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

Yes
2003 SP1

"Ron de Bruin" wrote:

> Do you use a English version ?
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Arturo" <[email protected]> wrote in message news:[email protected]...
> > 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
>
>
>

Use

Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = False



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Arturo" <[email protected]> wrote in message news:[email protected]...
> Yes
> 2003 SP1
>
> "Ron de Bruin" wrote:
>
>> Do you use a English version ?
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Arturo" <[email protected]> wrote in message news:[email protected]...
>> > 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
>>
>>
>>

Nice I like it.