Thread: xl2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default xl2007

There is probably a Visible property somewhere that you set to TRUE or
FALSE.

In Excel 2000, the line of code (to hide a commandbar) is:

Application.CommandBars("My CommandBar").Visible = False

Turn on the macro recorder and see what happens.
--
Regards,
Bill Renaud