View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Place this in the ThisWorkbook module of the target
workbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
End Sub

---
HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

I have a program that uses 2 workbooks. Both must be

visible. But the code
workbook with the graphics cannot be closed by the right

corner cross
clicking.

How can i prevent this from happening.

The code workbook closes automaticcly by closing the

other data workbook

Thenks for helping me out
.