Thanks a lot keepITcool! It works like a charm!
-----Original Message-----
Jason, it's not only possible.. it's easy :)
lock the windows of the activebook:
tools/protect/workbook
structure OFF
windows ON
PLUS
in this workbook
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Not blnByCode Then Cancel = True
End Sub
where blnByCode is a module lavel boolean variable you
can set in your
other macor to close the workbook.
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool
"Jason L." wrote:
Hello,
I've been looking for a way to disable the close ("X")
and shrink
buttons that are located at the upper-right part of
the spreadsheet.
This will ensure that the user uses the button
containing the macros I
have created.
Is this possible? Please help.
thanks in advance,
Jason
.