Assigining User Defined Functions to Categories in Addins

J

Jim

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Autoloading Addin with UDFs 3
#NAME? Error With User Defined Functions 7
Making User defined functions available in all new workbooks 5
UDF Add-in New category in "Paste Function Dialog Box" 1
Multiple User Defined Categories in Insert Function Form 2
AddIn Functions Have File Path and #NAME? Error 1
Macros and user-defined functions used in several workbooks 0
Problem with user functions in Add-ins for multiple persons 1

Top