When a user clicks 'X' button to close the calc, How can I prevent it by macro & back to the cell if mandatory field or cell are not inserted by data.

[Forhad]

When a user clicks ‘X’ button to close the calc, How can I prevent it by macro & back to the cell if mandatory field or cell are not inserted by data.

[anon73440385]

Please use a short title for your questions. It adds no additional information, if detailed description just repeats the heading.

[sokol92]

The veto technique for closing a document is described here