1 year ago

#377344

test-img

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

Accepted video resources