VBA not responding

Question

VBA not responding

Anonymous

Hi,

I had a VBA to generate automated invoices. It works fine in my last excel 2013, but since I changed to excel 2016, everytime I tried to run my VBA, it went into ''not responding '' mode and froze. I am not sure if the excel version is the problem. Can someone help?

Thanks!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

You could also have asked: "My coffee machine is not working, can someone tell me why?"

No, sorry, "not responding" can mean anything and has nothing to do with Excel, that message is from Windows.

Just a guess: In Excel 2016 there is a feature "Keep the copy"

https://techcommunity.microsoft.com/t5/Excel-Bl...

If you copy something you should disable the copy afterwards

Application.CutCopyMode = False

Otherwise:

For this kind of requests, please create a sample file with the layout of your original file, filled with sample data and colored cells with the expected result.

At best make a copy of your original file and anonymize the necessary data. For this please download this file

https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAn...

Open your Excel file

Right-click on the sheet tab

Choose "View Code"

Press CTRL-M

Select the downloaded file and import

Close the VBA editor

Select the cells with the confidential data

Press Alt-F8

Choose the macro Anonymize

Click Run

Upload it on OneDrive (or an other Online File Hoster of your choice) and post the download link here.

https://support.office.com/en-us/article/Share-...

Then we can look at the file and try to find a solution. Thank you for your understanding.

Andreas.

Share via

VBA not responding

1 answer