• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Disable the close file button

H

Harry Covair

Member
Hi the forum,
Should some people know the VBA instruction(s) to disable the close red cross on the top right of the title bar and force the user to close the file with a button in a worksheet?
Thanks in advance

Harry
 
Hello Narayan,
Thank you for the answer.
I tried a lookalike code but without success.
In fact an inappropriate instruction "Application.EnableEvents = False" prevented activate the event.
The problem is solved.
Have a nice day

Harry.
 
You must log in or register to reply here.
Back
Top