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

React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Add-in UDF to Catagory 2
Assigining User Defined Functions to Categories in Addins 0
Error with MarcoOptions method, add a new category 2
UDF from Add-In returning #NAME 0
Function Help in Add in 2
Putting UDF in custom or predefined function category 6

Top