VBA Button in user form opens new workbook and switches back to the original one

[Kra]

Hi all,

I have a small problem with my user form. One of buttons opens specific workbook - Raport.xlsm. It works fine, but if I click on any cell in Raport file, excel switches back to original workbook in which macro was used. Any way to keep opened workbook activated?

Private Sub CommandButton1_Click()

Unload Me
Workbooks.Open "C:\Local\Public\Raport.xlsm"

End Sub

 

[Logit]

I used your code provided above. I do not experience the same issue here. After clicking on the button on the UserForm, the second workbook opens after the userform closes.
Clicking on a cell in the second workbook does not replicate the issue you are seeing there.


???

 

[Kra]

I used your code provided above. I do not experience the same issue here. After clicking on the button on the UserForm, the second workbook opens after the userform closes.
Clicking on a cell in the second workbook does not replicate the issue you are seeing there.


???

Thank you for checking, I investigated everything and apparently one of add-ins was causing this trouble

 

[Logit]