MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2002

Posted by Fareed Mohammed on December 21, 2001 10:02 AM


The line below is using Excel 2000, where the names in brackets are the names of the toolbars and controls respectively. Could anyone please tell me how I would do this in Office XP Excel 2002. I juts get an error and I am not familar with the Excel 2002 object model.

CommandBars(gcMainMenuBar).Controls gcTBCtlWWDealsheet).Visible = True


Posted by Ivan F Moala on December 21, 2001 10:50 PM

CommandBars(gcMainMenuBar).Controls (gcTBCtlWWDealsheet).Visible = True