View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
turk5555[_3_] turk5555[_3_] is offline
external usenet poster
 
Posts: 1
Default How to make opening of workbook conditional of opening of another workbook

Would you happen to know what the VBA code would be and where I would
place it?

I used the following code and cannot get it to work:

Sub Workbook_Open()

If Workbooks.Open("Home") = False Then

ThisWorkbook.Close

End If

End Sub

I placed the above code in ThisWorkbook.


---
Message posted from http://www.ExcelForum.com/