Salt-N-Pepa. Note: In Excel 2007, this is a Statistical function. Note: In Excel 2007, this is a Statistical function.

1. Here
2. How To Use Formulas

Statistical: Returns the standard normal cumulative distribution Compatibility: Returns the standard normal cumulative distribution In Excel 2007, this is a Statistical function. Statistical: Returns the inverse of the standard normal cumulative distribution Compatibility: Returns the inverse of the standard normal cumulative distribution In Excel 2007, this is a Statistical function.

After I saved an xlsm file as an xlam file (an addin) and installed the addin. The help file can be displayed by clicking on the 'Help on this function' in Insert Function dialog box. However, after I closed Excel and opened again. The addin was still installed, but the help file cannnot be displayed.

To create an add-in, save your excel file that contains your VBA functions as an add-in file (.xla for Excel 2003 or.xlam for Excel 2007+). Then load the add-in (Tools > Add-Ins. For Excel 2003 or Developer > Excel Add-Ins for Excel 2010+). Be careful about using custom functions in spreadsheets that you need to share with others.

1. How to Provide Help with Office Applications Written in. The help file. Declare Function. Excel 2007 may leave your.chm file open and.
2. Excel functions (by category) Applies. Post a question in the Excel community forum. Help us improve Excel. Do you have suggestions about how we can improve the.

Here

How To Use Formulas

To get it displayed, I need to uninstall and re-install the addin again while Excel was still opened OR uninstall the addin, close the Excel, and install the addin again. Here is my code: Private Sub WorkbookAddinInstall Installed = True Application.MacroOptions 'AvgN', HelpFile:=ThisWorkbook.Path & ' AvgN Help.chm' End Sub How to get the help file displayed without needing to uninstall and re-install the addin again and again?