Add-in UDF to Catagory

C

C. Roenbaugh

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
 
B

Bob Phillips

What have you assigned to MyGroup variable?

--

HTH

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

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 - add a custom function to a custom group. 1
Having User Defined functions in their own Insert Function category? 1
XLA not opening properly (Repost) 3
Function Help in Add in 2
Putting UDF in custom or predefined function category 6
UDF Add-in New category in "Paste Function Dialog Box" 1
SpecialCells in UDF 2
Error with MarcoOptions method, add a new category 2

Top