UDF Add-in New category in "Paste Function Dialog Box"

C

C. Roenbaugh

I have created an addin that calculates Black-Scholes option greeks.
Using the MacroOptions method i have created a new catagory for my
functions. the problem is that I now get an error message when I start
excel. "Run time error '1004' cannot edit a macro on a hidden
workbook. Unhide the workbook using the Unhide comand."

Any ideas?

Here is the addin if anyone wants to take a look.

Thanks
Chris Roenbaugh



https://oncourse.iu.edu/access/content/user/jroenbau/bsoptions.xla
 

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

Add-in UDF to Catagory 2
Error with MarcoOptions method, add a new category 2
Putting UDF in custom or predefined function category 6
Having User Defined functions in their own Insert Function category? 1
Function Help in Add in 2
Add-in - add a custom function to a custom group. 1
Add-In UDF returning #NAME error 5
How to call user defined function (UDF) from custom menu in Excel2003? 3

Top