Excel 64-bit update crashes at SetTimer since lately

Question

My Excel VBA application supports 32-bit and 64-bit.
The last few Office 365 64-bit updates e.g. 16.0.14326.20262 crash my application at

SetTimer HWnd, 0&, INTERVAL, AddressOf TimerProc

It's the AddressOf command which is responsible for.
My application provides everything which has to do with PtrSafe that it works with Excel 64-bit.
The only chance to overcome the problem is to compile and run the application in exactly this 64-bit Excel built. Another built will crash Excel 64-bit again.
It's not feasible to manage my application versions by each single Excel 64-bit built number.
It worked for long that way that I compiled my application in Excel 32-bit and it run in Excel 64-bit as well.
But recently something changed in Excel 64-bit that it needs VBA compilation for each single built. Again, Excel 32-bit works fine with no restrictions.

Any ideas?

TIA
Reinhard

Answer 1

Hi @reinht ,
Welcome to Q&A forum!
Will this issue occur if you update Office to the latest version?

From the perspective of Office, please exit all Microsoft Office apps, and then add the following registry key to check this issue.

• Enter regedit in the Search Windows box, select Registry Editor to open it.
• Go to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options to create a new DWORD Value. Value Name: ForceVBALoadFromSource
  Value Type: REG_DWORD
  Value Data: 1

• Exit Registry Editor to check this issue.

If the above do not work, since I am not a VBA expert, I would suggets you refer to the following page to post a new question and provide the detailed code for more professional support.
Office developer community
Thanks for your understandin!

Hope the information is helpful to you.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.