I used to be able to enter UDF instructions from the VBA environment as
follows;
with cursor in some code, hit F2 to bring up the object browser, select your
library, select your UDF, right click, select Preferences and enter your
instructions in the Description box.
However, entered text is not saved.

Can anone advise?

(The workaround via the GDI works most of the time.)

It is in mine XL 2002 Win XP.

--
HTH

Bob Phillips

"OE" wrote in message
...
I used to be able to enter UDF instructions from the VBA environment as
follows;
with cursor in some code, hit F2 to bring up the object browser, select
your
library, select your UDF, right click, select Preferences and enter your
instructions in the Description box.
However, entered text is not saved.

Can anone advise?

(The workaround via the GDI works most of the time.)

I have both versions of Excel also (work / home), the problem is in both.

"Bob Phillips" wrote:

It is in mine XL 2002 Win XP.

--
HTH

Bob Phillips

"OE" wrote in message
...
I used to be able to enter UDF instructions from the VBA environment as
follows;
with cursor in some code, hit F2 to bring up the object browser, select
your
library, select your UDF, right click, select Preferences and enter your
instructions in the Description box.
However, entered text is not saved.

Can anone advise?

(The workaround via the GDI works most of the time.)

With these two problems it sounds like you have another problem causing it.

--
HTH

Bob Phillips

"OE" wrote in message
...
I have both versions of Excel also (work / home), the problem is in both.

"Bob Phillips" wrote:

It is in mine XL 2002 Win XP.

--
HTH

Bob Phillips

"OE" wrote in message
...
I used to be able to enter UDF instructions from the VBA environment
as
follows;
with cursor in some code, hit F2 to bring up the object browser,
select
your
library, select your UDF, right click, select Preferences and enter
your
instructions in the Description box.
However, entered text is not saved.

Can anone advise?

(The workaround via the GDI works most of the time.)

Did you remember to save that workbook with the UDF?

OE wrote:

I used to be able to enter UDF instructions from the VBA environment as
follows;
with cursor in some code, hit F2 to bring up the object browser, select your
library, select your UDF, right click, select Preferences and enter your
instructions in the Description box.
However, entered text is not saved.

Can anone advise?

(The workaround via the GDI works most of the time.)

--

Dave Peterson

The UDF was in Personal.xls (hidden) but after Unhide the problem remains.
Have given up, will use the GDI backdoor method. But thanks for all thoughts.

"Dave Peterson" wrote:

Did you remember to save that workbook with the UDF?

OE wrote:

I used to be able to enter UDF instructions from the VBA environment as
follows;
with cursor in some code, hit F2 to bring up the object browser, select your
library, select your UDF, right click, select Preferences and enter your
instructions in the Description box.
However, entered text is not saved.

Can anone advise?

(The workaround via the GDI works most of the time.)

--

Dave Peterson

Just an aside...Personally, I think going through Excel's GUI is much easier (to
explain and to do). I wouldn't have called it the workaround or backdoor.





OE wrote:

The UDF was in Personal.xls (hidden) but after Unhide the problem remains.
Have given up, will use the GDI backdoor method. But thanks for all thoughts.

"Dave Peterson" wrote:

Did you remember to save that workbook with the UDF?

OE wrote:

I used to be able to enter UDF instructions from the VBA environment as
follows;
with cursor in some code, hit F2 to bring up the object browser, select your
library, select your UDF, right click, select Preferences and enter your
instructions in the Description box.
However, entered text is not saved.

Can anone advise?

(The workaround via the GDI works most of the time.)

--

Dave Peterson


--

Dave Peterson