P
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
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