Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way of writing write code in an Excel95 workbook which
creates a CommandBar object (as distinct from a Toolbar object) when opened in later versions i.e. code must work in Excel97 onwards but not blow up in Excel95? My first thought was conditional compilation but I find it's not supported in Excel95 (VBA4?) My second thought was to create an instance using late binding but this won't work either. Not surprising because I know I can't instantiate a CommandBar using early binding anyway i.e. Dim oBar As Office.CommandBar Set oBar = New Office.CommandBar ' << compile error Any other ideas (or confirmation this just isn't possible)? -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Xfer of XL95 custom menus into XL97 | Excel Worksheet Functions | |||
Editing XL95 custom menus with XL97 | Excel Worksheet Functions | |||
Cannot create transparent XP CommandBar picture | Excel Programming | |||
Create new commandbar with call procedure | Excel Programming | |||
VBA for XL95, Workbook.open non XL-file | Excel Programming |