Code to bypass Msgbox Help

[Excelnoobisme]

Hi,

i have a worksheet "A" with msgbox popup when i attempt to close it.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim Response As Long

Response = MsgBox("Have you save a copy?", vbYesNo)
If Response = vbNo Then
Cancel = True
Else: ThisWorkbook.Saved = True
End If
End Sub


On worksheet "B" i have some link to Worksheet "A", and when i try to
Windows("A").close, it will show the above MsgBox. Is there any code to bypass it?

 

[Tom Urtis]

Not sure exactly what you are asking about.

First, I suspect by "worksheet" you really mean workbook. If that's the case, please clarify if you are asking to not have the message box appear if you quit Excel (close all workbooks). I mention that because you referenced closing Windows. Otherwise it's a mystery what you are talking about.

 

[Excelnoobisme]

Yes tom, i mean workbook. Im asking to not have the message box appear if i quit Excel (close all workbooks).But im not going to delete the code as it will serve the purpose for people working on that workbook alone.

I just wanted to bypass that msgbox alert if i close it after i transfering some data and when attempting to close it via vba

 

[Excelnoobisme]

Any1 can help me on this please