Function Help in Add in

[Pieter]

Hello:

I have an add in for Excel 2007 (also for earlier versions which does
not
have the problem). I cannot get the help file to display specific
topics.

Here is the code:

In the workbook code I have the following:

Private Sub Workbook_Open()
Call SetOptions
End Sub

Then in a regular module I have the following:

Option Explicit

Function fintest1(num)
fintest1 = num ^ 2
End Function

Sub SetOptions()
Application.MacroOptions Macro:="Fintest1", _
Description:="Square", _
Category:=14, _
HelpContextID:=25, _
HelpFile:=ThisWorkbook.Path & "\FinPak3test.chm"
End Sub

The help file is in same directory as the add in.
When Excel load I get an error that says:
Run-time error '1004'
Cannot edit a macro on a hidden workbook. Unhide the working using the
Unhide command.

If I choose debug the command that is highlighted is the
Applications.MacroOptions.....
If I click reset the add-in loads but the help file on the function
help will not work.
I get a message that it cannot be found. If I run the SetOptions
manually after loading Excel
there is no error and the help file is found. (I can use "resume
next ..." to eliminate the
error message, but not the underlying error.

IF I change to file to xlxm file and load it everything works, no
errors and
the help system works.

Any Suggestions? Thank you.

Pieter

 

[FSt1]

hi
for a 2007 file to run macros, it must be a .xlsm file extention.
2007 addins are a .xlam.
see this site...
http://office.microsoft.com/en-us/help/HA100069351033.aspx

regards
FSt1

 

[Pieter]

Hello:

Thank you for your reply but that is not the problem. I know that
macros work for xlam files and xlsm files.
My problem is with this specific macro within an xlam file. All of the
other macros work fine
in the xlam file.

Pieter