Hi,

In my option, the line of code may be not a source of the problem.
around 2000 lines may not matter.
please find another source of the problem.

"Neeraja" wrote in message
...
Hi,

Could someone let me know how many lines of code can be
written in a MAcro using VB editor in an Excel file.
Becuase i have written a MAcro which contains around 2000
lines of code (25 Procedures and a few functions). My
Excel file doesn't open now.

Actually the macro was performing well. I included a few
lines of code and saved and then closed the Excel file.
Now when i reopen this,, if i Disable the Macro the file
opens. But when i enable the macro,, it doesn't respond.

Is this because of the lengthy code or some other
problem. I even restarted the system.

I appreciate any help.
Neeraja.