I have a xls with lots of macros in it and its crashing on open

i am still trying to find the exact location of the crash, but i am
suspecting its on a command where its LOAD <FORMNAME

the crash: I get a File/Path error, then its a popup with Error 75,
then its a Catastrophic error, &H8000FFFF. (Fun stuff!!!)

there is a way around this, but its weird, if i open the sheet, disable
macros, save it, close it, then reopen, enable macros, it works fine

BUT the really weird thing is, the file size of the sheet changes, any
ideas why this would happen? and its not a small change either, the
bigger the initial file size, the bigger the change


--
Anthony Fok
------------------------------------------------------------------------
Anthony Fok's Profile: http://www.excelforum.com/member.php...o&userid=16832
View this thread: http://www.excelforum.com/showthread...hreadid=391039