preventing from user to leave a sheet

[#1]

hello,

is it possible to prevent from the user to leave a sheet?

what i have today is, a trigger "OnLeaveSheet" that call a macro that present the user a Yes No msgbox,

my problem is that the user sees the other sheet, the one that he leave for.

i need that the msgbox will appear in the sheet before leaving.

thank you all.

[swuehl]

Maybe you could hide the tabrows (settings - document properties - general) and use a set of custom buttons to navigate and check for allowance.