Disable closing workbook

[Edcel]

Hello,

I've written a macro wich first protects the worksheet with a password and then closes the workbook.

I want other users to use this macro and not be able to close the workbook with CTR-F4 or by clicking on the cross on the right top corner.

Does anyone know how to disable these options or better, how to connect these to my macro?

Greetings,
Edcel.

[MattShoreson]

why dont you put the protect macro as follows:

sub auto_close

[your protect code here]

end sub

it must be called auto_close!

This will run when the workbook is closed.

[Edcel]

I've tried it but it doesn't work.

Should it be a class or private?

Any other suggestions?

Edcel.

[Edcel]

Forget what I've replied.

Tried it again in a different module and it works.

Thanx!!