Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Help in Add in
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Help in Add in
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/he...069351033.aspx regards FSt1 "Pieter" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Help in Add in
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 On Jul 5, 9:16*pm, FSt1 wrote: 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/he...069351033.aspx regards FSt1 "Pieter" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions |