Hi,

i inherited an Excel file that contain macro, vba code, udf. When i open it
using X2003 and select 'disable macro', a message box pops up, saying that
the file has Excel 4 Macro that cannot be disable.

Now i need to edit the UDF, i can see that this workbook has UDF from the
Insert Function menu. The problem is when i try to search the UDF, i can't
find it anywhere. I did search all modules using VBA Editor and the search
came back empty.


My questions a
- does this happen because the file has Excel 4 Macro that can't be disable?.
- how can i edit Excel 4 macro using Excel 2003?.
- how can edit the UDF?

best regards,

Trias H

What is UDF mean?

usually in such case, I will create a new Excel to copy all the sheets and
re-create all the module and copy all codes into Excel2003.

File produced by Excel earlier version may get hidden problem that cannot be
solved easily. Also, you might need to recreate button object and some
graphic elements which cause the biggest trouble when open with a new version
of Excel.

Don't forget to point the button into correct macro. In most case, old
version macro will work.

Hope this help

regards

Leung





"Trias" wrote:

Hi,

i inherited an Excel file that contain macro, vba code, udf. When i open it
using X2003 and select 'disable macro', a message box pops up, saying that
the file has Excel 4 Macro that cannot be disable.

Now i need to edit the UDF, i can see that this workbook has UDF from the
Insert Function menu. The problem is when i try to search the UDF, i can't
find it anywhere. I did search all modules using VBA Editor and the search
came back empty.


My questions a
- does this happen because the file has Excel 4 Macro that can't be disable?.
- how can i edit Excel 4 macro using Excel 2003?.
- how can edit the UDF?

best regards,

Trias H

Trias,
I think the problem may be more simple than that.
Select "Tools", "Macro","Macros"
In the dialogue box that pops up, "Macro In:" box make sure the workbook
that you are using is selected. IF the "UDF" macro is not listed, then it was
created and this box was on "All Open Workbooks". You may be able to select
"This Workbook" and edit and be able to fix it.
HTH

"Trias" wrote:

Hi,

i inherited an Excel file that contain macro, vba code, udf. When i open it
using X2003 and select 'disable macro', a message box pops up, saying that
the file has Excel 4 Macro that cannot be disable.

Now i need to edit the UDF, i can see that this workbook has UDF from the
Insert Function menu. The problem is when i try to search the UDF, i can't
find it anywhere. I did search all modules using VBA Editor and the search
came back empty.


My questions a
- does this happen because the file has Excel 4 Macro that can't be disable?.
- how can i edit Excel 4 macro using Excel 2003?.
- how can edit the UDF?

best regards,

Trias H