UDF categorisation

In previous versions of Excel, I could categorise UDFs using;

Application.MacroOptions Macro:="myUDF", Category:=2

(for Date & Time functions)

but now I get an error :
Method 'MacroOptions' of object '_Application' failed. [note the leading
underscore].

This is as used for quite sometime & appears in Help of Excel 2002 & XP. Any
clues?

It worked okay for me, but I could force it if I made the function private.

--
HTH

Bob Phillips

"OE" <[email protected]> wrote in message
news:[email protected]...
> In previous versions of Excel, I could categorise UDFs using;
>
> Application.MacroOptions Macro:="myUDF", Category:=2
>
> (for Date & Time functions)
>
> but now I get an error :
> Method 'MacroOptions' of object '_Application' failed. [note the leading
> underscore].
>
> This is as used for quite sometime & appears in Help of Excel 2002 & XP.
Any
> clues?
>

Have tried making the function Private but to no avail. I wonder if it's a
VBA reference?

"Bob Phillips" wrote:

> It worked okay for me, but I could force it if I made the function private.
>
> --
> HTH
>
> Bob Phillips
>
> "OE" <[email protected]> wrote in message
> news:[email protected]...
> > In previous versions of Excel, I could categorise UDFs using;
> >
> > Application.MacroOptions Macro:="myUDF", Category:=2
> >
> > (for Date & Time functions)
> >
> > but now I get an error :
> > Method 'MacroOptions' of object '_Application' failed. [note the leading
> > underscore].
> >
> > This is as used for quite sometime & appears in Help of Excel 2002 & XP.
> Any
> > clues?
> >
>
>
>

Sorry, I meant that I can force the error if I make the function private,
that is it works okay as a public function.

--
HTH

Bob Phillips

"OE" <[email protected]> wrote in message
news:[email protected]...
> Have tried making the function Private but to no avail. I wonder if it's a
> VBA reference?
>
> "Bob Phillips" wrote:
>
> > It worked okay for me, but I could force it if I made the function
private.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "OE" <[email protected]> wrote in message
> > news:[email protected]...
> > > In previous versions of Excel, I could categorise UDFs using;
> > >
> > > Application.MacroOptions Macro:="myUDF", Category:=2
> > >
> > > (for Date & Time functions)
> > >
> > > but now I get an error :
> > > Method 'MacroOptions' of object '_Application' failed. [note the
leading
> > > underscore].
> > >
> > > This is as used for quite sometime & appears in Help of Excel 2002 &
XP.
> > Any
> > > clues?
> > >
> >
> >
> >

the macro name needs to be found..
no problems if the UDF is public, the module is public the workbook is
active etc..

if you cant guarantee that then..
following will explicitly describe where the macro can be found.
and will work regardless

Although i wouldnt put my UDFs in an object module

Sub foo()
Application.MacroOptions Category:=3, _
Macro:=ThisWorkbook.VBProject.Name & ".module1.myudf"
Application.MacroOptions Category:=3, _
Macro:=ThisWorkbook.VBProject.Name & ".sheet1.myudfsheet"
End Sub

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


OE wrote :

> In previous versions of Excel, I could categorise UDFs using;
>
> Application.MacroOptions Macro:="myUDF", Category:=2
>
> (for Date & Time functions)
>
> but now I get an error :
> Method 'MacroOptions' of object '_Application' failed. [note the
> leading underscore].
>
> This is as used for quite sometime & appears in Help of Excel 2002 &
> XP. Any clues?

Have found the cause; both the categorisation sub and the UDF were in
Personal.xls which was hidden. Worked fine once unhide was invoked. Thanks to
all for your responses.

"keepITcool" wrote:

>
>
> the macro name needs to be found..
> no problems if the UDF is public, the module is public the workbook is
> active etc..
>
> if you cant guarantee that then..
> following will explicitly describe where the macro can be found.
> and will work regardless
>
> Although i wouldnt put my UDFs in an object module
>
> Sub foo()
> Application.MacroOptions Category:=3, _
> Macro:=ThisWorkbook.VBProject.Name & ".module1.myudf"
> Application.MacroOptions Category:=3, _
> Macro:=ThisWorkbook.VBProject.Name & ".sheet1.myudfsheet"
> End Sub
>
> --
> keepITcool
> | www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
> OE wrote :
>
> > In previous versions of Excel, I could categorise UDFs using;
> >
> > Application.MacroOptions Macro:="myUDF", Category:=2
> >
> > (for Date & Time functions)
> >
> > but now I get an error :
> > Method 'MacroOptions' of object '_Application' failed. [note the
> > leading underscore].
> >
> > This is as used for quite sometime & appears in Help of Excel 2002 &
> > XP. Any clues?
>