View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Arturo Arturo is offline
external usenet poster
 
Posts: 108
Default 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