How do I disable worksheet close method

J

Jenny

Hello.

All I need to know is how to disable a user's ability to
close a worksheet using the close button in the upper
right-hand corner of the worksheet window.

Any help is greatly appreciated.

~Jenny
 
F

Frank Kabel

Hi
you can't close a single worksheet. This 'X' will close the current
active window 8but not a single worksheet)
 
J

Jenny

Oh, I see what you are saying.

Let me rephrase the question <smile> If I have multiple
workbooks open, how can I programmatically prevent the
users from using the close button (or file option) to
close the workbook? I need that all to be done through my
code.

~Jenny
 
Top