If there are two or more workbooks currently opened up then ask the user to close the other one...

[omairhe]

Hello Excel Gurus,

How are you? I want to learn about a macro that can prompt user to close all other workbooks so that only one active workbook is opened.

Is it possible?

Thanks and will appreciate any help.

 

[omairhe]

Sub TestingWorkbookOpen()
othwb = Application.Workbooks.Count
If othwb > 1 Then
MsgBox "Please close all other workbooks before adding a new item."
End If
End Sub

Got it ..
nevermind.