Launching Help from F1 on Keyword
 

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

Launching Help from F1 on Keyword
 

Don't worry - I fixed it myself - It was an issue with our IT Dept and their
obsession with locking things down.

"PaulLondon" wrote:

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