hallo onderstaande code loopt bij mij op de computer wel juist, maar een collega krijgt een foutmelding: Hoe kan ik dit in onderstaande code oplossen
foutmelding is: kan project of bibliotheek niet vinden
foutmelding is: kan project of bibliotheek niet vinden
Code:
[COLOR="Red"][B]Private Sub Workbook_BeforeClose(Cancel As Boolean)[/B][/COLOR] ActiveWindow.DisplayWorkbookTabs = True
Application.DisplayFormulaBar = True
Application.DisplayScrollBars = True
Application.DisplayStatusBar = True
Dim Save As Boolean
Application.ScreenUpdating = False
Save = True
If ThisWorkbook.Saved = False Then
a = MsgBox("Wilt u de wijzigingen opslaan?", vbYesNoCancel, "gegevens opslaan
If a = vbCancel Then Cancel = True
If a = vbNo Then Save = False
End If
If Save = False Then
ThisWorkbook.Saved = True
End If
If Cancel = False And Save = True Then
Blad1.Visible = xlSheetVisible
Blad1.Visible = True
HideAll
ThisWorkbook.Save
End If
End Sub
Private Sub Workbook_Open()
UnHideAll
Blad2.Activate
ActiveWindow.DisplayWorkbookTabs = False
Application.DisplayFormulaBar = False
Application.DisplayScrollBars = False
Application.DisplayStatusBar = False
ActiveSheet.Protect ("joppe")
Blad1.Visible = xlSheetHidden
End Sub
Private Sub HideAll()
'Blad1.Visible = xlSheetVisible
Blad2.Visible = xlSheetHidden
Blad3.Visible = xlSheetHidden
End Sub
Private Sub UnHideAll()
'Blad1.Visible = xlSheetHidden
Blad2.Visible = xlSheetVisible
Blad3.Visible = xlSheetVisible
Application.ScreenUpdating = True
End Sub