Can't reach VBA code anymore

[lisaliezaa]

Hi,

I have made a form with VBA. Now I did something stupid: I wrote code, that does the following: if someone closes the form, or pushes the button save, than the form closes itself and the .xls file. Which has the result that I can't reach the code anymore and make changes.

Is there a way around this so I can still reach the code?

Regards,
Lisa

 

[Weaver]

Does the form automatically open when you open the file? If so, disable macros before you open it. Otherwise you should be able to get to the code anyway, before you close anything.