ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   UDF Add-in New category in "Paste Function Dialog Box" (https://www.excelbanter.com/excel-worksheet-functions/54816-udf-add-new-category-paste-function-dialog-box.html)

C. Roenbaugh

UDF Add-in New category in "Paste Function Dialog Box"
 
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


C. Roenbaugh

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



All times are GMT +1. The time now is 01:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com