my workbook is stop debugging and make excel not responding

[suny100]

hi my workbook contains alot of codes but it works very well but i have just one sheet which is make excel not responding when i delete any row from it , it happen one time before and i was have to rebuild my workbook in new one but now i can't do that, so what could i do to get over this problem???????????

[MarvinP]

Hi suny100,

If you have VBA code behind your workbook and the code is faulty, it can give this problem. For example, if your code does an

Please Login or Register  to view this content.

this could make your workbook not work. You might also have other VBA code that is turning the Screen off. If an error happens in the code and these normal things aren't turned on you would be stuck.

I'd suggest you close your workbook and open the copy of it or an older version and see what the VBA code is doing and find where these things are going bad.

Without seeing your code or understanding your problem better, the above is simply a guess.

[suny100]

Hi suny100,

If you have VBA code behind your workbook and the code is faulty, it can give this problem. For example, if your code does an

Please Login or Register  to view this content.

this could make your workbook not work. You might also have other VBA code that is turning the Screen off. If an error happens in the code and these normal things aren't turned on you would be stuck.

I'd suggest you close your workbook and open the copy of it or an older version and see what the VBA code is doing and find where these things are going bad.

Without seeing your code or understanding your problem better, the above is simply a guess.

No I haven't any of this codes it contain normal code for cut and delete rows upon specific criteria and this "Not responding " is happening if i even delete manually a row in specific sheet not in all workbook and this sheet just contain 2 buttons with simple code but i don't know where is the mistak

[MarvinP]

Hi suny100

I can't help much more without seeing the code or a sample workbook that produces the problem.

[suny100]

Hi suny100

I can't help much more without seeing the code or a sample workbook that produces the problem.

thanks for your care
here is sample workbook , the problem is in 'full" sheet , if you try to delete row or when you click on finished button