Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,025
OK - I am flat stumped...
Tried to download COLO's add-in at work. Couldn't. Tried at home could. Installed it. Could not figure out how to use it - which was quite embarrassing since it appeared to be dead-bang obvious to everyone.
Turns out it's not displaying the menu. I went in and stepped through the code as it opens and runs CreateMenu() and CreateReferences(). After CreateMenu(), I can switch over to Excel from VB Editor and voilá, there's the HTML menu. After CreateReferences() executes Html menu is still there. Hit [F8] once more to pass the End Sub of HTMLMaker's WB_Open() method and bang... it's gone.
I temporarily removed my PERSONAL wb to see if something there might be affecting it. Html menu still disappears.
If anyone knows how to solve this one, I'd be much obliged 'cause I'm outta ideas.
Thanks,
Greg
Excel: 2002
OS: Win XP Home Edition
Other add-ins installed are:
- Analysis Toolpak
- Analysis Toolpak - VBA
- Conditional Sum Wizard
- Lookup Wizard
- Solver Add-In
References in VB:
- Visual Basic for Applications [Path is too long to see filename but directory is VBA6]
- MS Excel 10.0 Object Library
- OLE Automation
- MS Office 10.0 Object Library
- MS Forms 2.0 Object Library
- MS Scripting Runtime
- MS Visual Basic for App Extensibility 5.3
- MS Outlook 10.0 Object Library
Tried to download COLO's add-in at work. Couldn't. Tried at home could. Installed it. Could not figure out how to use it - which was quite embarrassing since it appeared to be dead-bang obvious to everyone.
Turns out it's not displaying the menu. I went in and stepped through the code as it opens and runs CreateMenu() and CreateReferences(). After CreateMenu(), I can switch over to Excel from VB Editor and voilá, there's the HTML menu. After CreateReferences() executes Html menu is still there. Hit [F8] once more to pass the End Sub of HTMLMaker's WB_Open() method and bang... it's gone.
I temporarily removed my PERSONAL wb to see if something there might be affecting it. Html menu still disappears.
If anyone knows how to solve this one, I'd be much obliged 'cause I'm outta ideas.
Thanks,
Greg
Excel: 2002
OS: Win XP Home Edition
Other add-ins installed are:
- Analysis Toolpak
- Analysis Toolpak - VBA
- Conditional Sum Wizard
- Lookup Wizard
- Solver Add-In
References in VB:
- Visual Basic for Applications [Path is too long to see filename but directory is VBA6]
- MS Excel 10.0 Object Library
- OLE Automation
- MS Office 10.0 Object Library
- MS Forms 2.0 Object Library
- MS Scripting Runtime
- MS Visual Basic for App Extensibility 5.3
- MS Outlook 10.0 Object Library