Thread: If syntax to test if command button exists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikeburg[_36_] mikeburg[_36_] is offline
external usenet poster
  
Posts: 1
Default If syntax to test if command button exists

I'm having trouble coming up with the exact syntax for an if statement
to determine if the following command button exists (so code will be
automatically excuted if it does exist):

Application.CommandBars(1).Controls("TestCode")

Any & all help would be greatly appreciated. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=471962

Reply With QuoteReply With Quote