View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
 
Posts: 459
Default Create CommandBar in xl95 code - possible?

JKP,
Good thinking! When I put sub NeverNever in a separate module I get no
error. Many thanks.

--

Jan Karel Pieterse wrote in message ...
Hi Onedaywhen,

Thanks for the suggestion but it didn't work I'm afraid. I wrote this
sub which is never called:

Sub NeverNever()
Dim c As CommandBar


Maybe defining c as an object will pass the test?
Or maybe putting all non-95 stuff in a separate module?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com