Workbook_BeforeClose event

[Charles Bushby]

When I open an excel file the workbook open event runs code to disable cut, copy and paste and hides the formula bar. When the file is closed I wish to enable cut, copy and paste and show the formula bar. I have tried the following code but it doesn't work. Does anyone know how to write code to make it work?

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Cancel = True Then
Call EnableCutAndPaste
Application.DisplayFormulaBar = True
ElseIf Cancel = False Then
Call DisableCutAndPaste
Application.DisplayFormulaBar = False
End If
End Sub

 

[Jaafar Tribak]

I think you have the Cancel thingy te other way around

Should be like this :

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Cancel = False Then
Call EnableCutAndPaste
Application.DisplayFormulaBar = True
ElseIf Cancel = True Then
Call DisableCutAndPaste
Application.DisplayFormulaBar = False
End If
End Sub

Regards.

 

[mikerickson]

I'd think about putting that in the Workbook_Deactivate code, so that I could have another workbook open at the same time as the disabled one.