E
Ed
In my Excel Add-in I place a custom menu on the menu bar. Selection of
a choice under the new menu item
brings up a user form. I'd like to have context sensitive help appear
when the form is in focus and the user hits
F1. I've read The VBA Help on the matter and have tried several
things. First, I set the HelpFile property
and the HelpContextID of both the Add-in (.xla) project and the .xls
project. This had no effect whatever.
I also tried putting this code in the function where I create the
custom menu:
MenuObject.HelpFile =
"d:\JOC\Membership\Doc\Help\JOCADDINUSAGE.HLP"
MenuObject.HelpContextID = 8
Again, no joy.
I created my help file using Doc-To-Help 6.0 that I happened to have.
Advice appreciated.
Ed
a choice under the new menu item
brings up a user form. I'd like to have context sensitive help appear
when the form is in focus and the user hits
F1. I've read The VBA Help on the matter and have tried several
things. First, I set the HelpFile property
and the HelpContextID of both the Add-in (.xla) project and the .xls
project. This had no effect whatever.
I also tried putting this code in the function where I create the
custom menu:
MenuObject.HelpFile =
"d:\JOC\Membership\Doc\Help\JOCADDINUSAGE.HLP"
MenuObject.HelpContextID = 8
Again, no joy.
I created my help file using Doc-To-Help 6.0 that I happened to have.
Advice appreciated.
Ed