1 year ago
#377344
Sfagnum
Worksheet_SelectionChange() not firing on a specific PC
I have .xlm file shared in network.
It work fine for another users, on other PCs, but on a specific PC some macros from this file works, but Worksheet_SelectionChange()
not working.
What else should I do on this PC?
Excel 2019
Code in right place (Sheet1)
Can't create new file and move code to it. (to much another code + forms)
In the immediate window:
?Application.EnableEvents True
UPD: Just test:
Private Sub Workbook_Open()
MsgBox "test"
End Sub
not working too.
And found one very strange thing:
Sub test()
Application.EnableEvents = True
End Sub
give error:
Run-time error '429':
ActiveX component can't create object
in Immediate
?Application.EnableEvents
True
ok
- Add-ins empty (by default)
- References under password
and one else, problem only with specific workbook on specific PC and problem with Events. Another WB works on this PC. This WB work on another PC. Crazy.
excel
vba
ms-office
0 Answers
Your Answer