ZVI
MrExcel MVP
- Joined
- Apr 9, 2008
- Messages
- 3,875
- Office Version
- 2019
- 2016
- 2010
- Platform
- Windows
For compatibility with 64bit versions of Excel it is required to replace in the module modMain this code line in the top:It doesn't working for me. I'm using ms excel 2016 64bit with windows 8 os. I followed the instructions - unblocking the file, tweaking on trust center settings and stuff. Good thing the forum tool add-in works on me
Rich (BB code):
Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwndLock As Long) As Long
by those lines:
Rich (BB code):
#If VBA7 Then
Declare PtrSafe Function LockWindowUpdate Lib "user32" (ByVal hwndLock As LongPtr) As Long
#Else
Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwndLock As Long) As Long
#End If