MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2002


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

Hi,

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


Thanks!



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

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