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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

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