chm Help file for User-Defined Function

kelvin004my

New Member
Joined
Jun 26, 2015
Messages
1
I manage to display the chm help file to an User-Defined Function by clicking on the "Help on this function" in Insert Function dialog box. This was possible only when the my file is xlsm.

After I saved the xlsm file as an xlam file (an addin) and installed the addin. The help file can be displayed too.
However, after I closed Excel and opened again. I would get runtime error 1004. The addin was still installed, but the help file cannnot be displayed. To get it displayed, I need to uninstall and re-install the addin again while Excel was still opened.

How to get the help file displayed without getting runtime error 1004 and without needing to uninstall and re-install the addin again and again? Thank you.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,215,437
Messages
6,124,871
Members
449,192
Latest member
MoonDancer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top