disable close and shrink buttons

J

Jason L.

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
 
K

keepITcool

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

Jason

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 >




.
Click to expand...
 
Top