How can I code this.
[vba]
Private Sub Workbook_Activate()
If "workbook.filename <> book1.xls" then
application.quit
Else
'Open the Workbook"
End if
[/vba]
How can I code this.
[vba]
Private Sub Workbook_Activate()
If "workbook.filename <> book1.xls" then
application.quit
Else
'Open the Workbook"
End if
[/vba]
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
[VBA]Private Sub Workbook_Activate()
If ThisWorkbook.Name <> "Book1.xls" Then Application.Quit
End Sub
[/VBA]
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.