Excel VBA not working after upgrading to Windows 10 from Windows 7

Hi

I've been searching the Microsoft forums but have found nothing for my particular issue.

I'm running Office 10 x32 on Windows 10 x64. I got the free Windows 10 upgrade from Windows 7 a few days ago.

I've started a new excel workbook and found my code is not being triggered as I'd expect. At first I thought my code was wrong but the odd thing is that my code will run once and then stop and won't run again unless I close the workbook and re-open. And then it will only run once until I close and reopen... the cycle continue.

The upshot is that whatever I write is useless even if it's correct because it plays once only... and even if my code has errors, they are untestable because after one iteration, I can't go into again to test the various "If Then" scenarios.

As a test I typed the following simple code. And NOTHING happened. It worked only after I saved the book and reopened it. But as soon as I flicked worksheets and came back to it, it stopped working.

Please Login or Register  to view this content.

Has this happened to anyone else? Is there a solution?

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

I tested your code on my Win 10 machine (Office 2013-32 bit) and was unable to replicate your issue. Your code works for me. I am on a 64 bit machine also.