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?

Look here:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Spencer Hutton" <(E-Mail Removed)> wrote in message
news:8C02AAEA-F255-4547-88A8-(E-Mail Removed)...
|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?