Assigining User Defined Functions to Categories in Addins
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?
|