You can't change macro properties in hidden workbook.
There are several ways to solve your problem.
1. Set IsAddin property of your add-in workbook to off,
then using Object Browser edit macro properties, set IsAddin to on again,
and save it.
2. Use FunCustomize.dll, which is freely available via Internet. It is very
easy and convenient tool to add description and category to you UDFs(sub or
functions)

"Jim" wrote:

I have an addin which contains several user defined functions. I am using
the Application.MacroOptions command to assign the functions to custom
categories. An example is:

Application.MacroOptions Macro:="BaPeq", Category:="Miscellaneous Functions"

The addin installs without any problems when loading the addin with Excel
already opened using Tools€¦Addins. But when I try to have Excel autoload the
addin every time Excel starts the I get the following error message:

Run-time error €˜1004
Cannot edit a macro on a hidden workbook. Unhide the workbook using the
unhide command.

Any suggestions on how to avoid this error message?