ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add-in UDF to Catagory (https://www.excelbanter.com/excel-programming/345442-add-udf-catagory.html)

C. Roenbaugh

Add-in UDF to Catagory
 
I am trying to add a group of custom functions to a custom catagory.
Currently I am using:

Private Sub Workbook_Open()
Application.MacroOptions Macro:="Myfunction", _
Category:=Mygroup


End Sub

It's not working, and I am geting a 1004 runtime error.

Any help would be appreciated.

Thanks

Chris Roenbaugh


Bob Phillips[_6_]

Add-in UDF to Catagory
 
What have you assigned to MyGroup variable?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"C. Roenbaugh" wrote in message
oups.com...
I am trying to add a group of custom functions to a custom catagory.
Currently I am using:

Private Sub Workbook_Open()
Application.MacroOptions Macro:="Myfunction", _
Category:=Mygroup


End Sub

It's not working, and I am geting a 1004 runtime error.

Any help would be appreciated.

Thanks

Chris Roenbaugh




C. Roenbaugh

Add-in UDF to Catagory
 
Fixed the problem with FUNCUSTOMIZE.DLL from http://xcell05.free.fr/

Thanks

CR



All times are GMT +1. The time now is 10:00 PM.

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