Sorry for my missunderstanding. I ll copy codes before and after.
Private Sub CommandButton2_Click()
On Error GoTo Klaida
Workbooks.Open Filename:="\\linktoworkbook\Žaliavų sąrašas\zaliavos.xlsm"
Workbooks("zaliavos.xlsm").Sheets("mdp").Activate
Exit Sub
Klaida:
MsgBox ("Lentelė atidaryta"), vbExclamation, "Klaida"
End Sub
This code is good, but when I send it to my colleague, code becomes:
Private Sub CommandButton2_Click()
On Error GoTo Klaida
Workbooks.Open Filename:="\\\linktoworkbook\Þaliavø sàraðas\zaliavos.xlsm"
Workbooks("zaliavos.xlsm").Sheets("mdp").Activate
Exit Sub
Klaida:
MsgBox ("Lentelë atidaryta"), vbExclamation, "Klaida"
End Sub
I start to think, that our language is not installed into my colleague computer, and thats the problem.
Bookmarks