Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COM Error Hiding/Showing Excel Toolbars
I am trying to hide or show Excel Toolbars form VB.Net automation but keep getting Com exceptions on the code below
The error message typically says call rejected by callee, and I can sometimes determine which commandbar is being referred to from the watch window, but not always. it started to occur when trying to restore visibility of toolbars on closing application, but now also occures on hiding Code I'm using is as follows For y = 1 To xlapp.CommandBars.Coun If CStr(xlapp.CommandBars(y).NameLocal) < "Worksheet Menu Bar" The If xlapp.CommandBars(y).Visible The ReDim Preserve xlTBarNames(x xlTBarNames(x) = xlapp.CommandBars(y).NameLocal.ToStrin x += End I End I Next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, hiding and showing sheets | Excel Discussion (Misc queries) | |||
Showing custom toolbars on one W/S only | Excel Discussion (Misc queries) | |||
Hiding all toolbars | Excel Discussion (Misc queries) | |||
Hiding all Toolbars | Excel Programming | |||
Hiding Toolbars Question | Excel Programming |