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/conte.../bsoptions.xla