A Macro that sometimes stops working

[ramlineses]

Hello,

In this file, there are macro codes under "Create Proposal" sheet, from rows 15 to 25, if the file is opened for quite some time or after few uses, the macro then will stop working, when you change the Inverter Brand the Model should change based on the brand, but the problem is sometimes it will stop working, if you keep on changing the brand nothing happens under the model drop down.

What we do is we close all applications opened, all excel window and reopen the file and it will work again, we wouldnt want to do this over and over again, Please help

[AlphaFrog]

Comment out or remove the lines On Error Resume Next. They would hide any code errors that may occur. Then if the code does error, report back the error number, description, and what line is highlighted when you click the Debug button on the error dialog.

[ramlineses]

I have removed the line On Error Resume Next and the Application update false line...however I am getting the error below everytime I edit a macro.

We found a problem with some content in "filename". Do you want us to try recover as much as we can? If you trust the source of this workbook click Yes

Then the macro is all messed up. please help, some created this code and we are no longer able to contact that person

[ramlineses]

Also, there are no debug error showing, it just stops working, the data validation drop down wont change

[ramlineses]

Please help

[ramlineses]

please help