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
.
|