Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
UDF can't be editted due to Excel 4 macro?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
How do I hide macros in Excel so they can't be editted? | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Macro - Open Word with Excel macro | Excel Discussion (Misc queries) |