Thread: Creating sub menu in Command bar
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
micklloyd[_3_] micklloyd[_3_] is offline
external usenet poster
  
Posts: 1
Default Creating sub menu in Command bar

Thanks Tom

FindControls only seems to work for all commandbars as follows (Office
VBA help as suggested):

"Set cntrls = CommandBars.FindControls(Type:=msoControlDropdown) "

but not on an individual commandbar such as:

"Set cntrls =
CommandBars("DTSheet").FindControls(Type:=msoContr olDropdown)"

It replies with a "Method or data member not found".

Regards
Mick


--
micklloyd
------------------------------------------------------------------------
micklloyd's Profile: http://www.excelforum.com/member.php...o&userid=30696
View this thread: http://www.excelforum.com/showthread...hreadid=383809

Reply With QuoteReply With Quote