S
Spencer Hutton
I have an Add-in that contains several custom functions. i want to add them
to a custom function category group named "MyFunctions". Here is the code i
have that runs with the Workbook_Open event.
Sub AddFunctionsToCategory()
Application.MacroOptions Macro:="FUNCNAME", Description:="Function Desc",
Category:= "MyFunctions"
End Sub
However, when the add-in loads, i receive a run-time error 1004 "Cannot edit
a mcaro on a hidden workbook" the .xla file is set to IsAddIn = True and i
dont want to unhide/rehide it with VBA before it loads. what is the answer?
to a custom function category group named "MyFunctions". Here is the code i
have that runs with the Workbook_Open event.
Sub AddFunctionsToCategory()
Application.MacroOptions Macro:="FUNCNAME", Description:="Function Desc",
Category:= "MyFunctions"
End Sub
However, when the add-in loads, i receive a run-time error 1004 "Cannot edit
a mcaro on a hidden workbook" the .xla file is set to IsAddIn = True and i
dont want to unhide/rehide it with VBA before it loads. what is the answer?