P
PaulLondon
Hi
I have a VB ActiveX Control and .CHM file. I can use this in Excel, and type
a line that references the Classes and Methods in the Control, eg
Cubes("MyCube").Delete
If I then put the cursor on '.Delete' and press F1, it wil launch Help at
the appropriate Context Id associated with the Delete Method in the Help CHM
file.
However, when I set up my classes in an XLA, rather than an ActiveX Control,
and then create a second Excel workbook that references the XLA, I find that
at best I can get it to open Help, but on a blank screen rather than the
Context Id associated with the keyword.
Is there a way around this? Why does this work when the classes are in an
ActiveX Control but not an XLA?
I have created a reference to the XLA in the second Excel workbook
Any help appreciated (sorry no pun intended).
Regards
Paul
I have a VB ActiveX Control and .CHM file. I can use this in Excel, and type
a line that references the Classes and Methods in the Control, eg
Cubes("MyCube").Delete
If I then put the cursor on '.Delete' and press F1, it wil launch Help at
the appropriate Context Id associated with the Delete Method in the Help CHM
file.
However, when I set up my classes in an XLA, rather than an ActiveX Control,
and then create a second Excel workbook that references the XLA, I find that
at best I can get it to open Help, but on a blank screen rather than the
Context Id associated with the keyword.
Is there a way around this? Why does this work when the classes are in an
ActiveX Control but not an XLA?
I have created a reference to the XLA in the second Excel workbook
Any help appreciated (sorry no pun intended).
Regards
Paul