Hi everyone!
I hope you all are fine and doing well in excel.
Here I need your help regarding Excel Close Button.
I want to disable X button of Excel Application.
File is attached as example
Please give me any solution.
Thank you so much
Hi everyone!
I hope you all are fine and doing well in excel.
Here I need your help regarding Excel Close Button.
I want to disable X button of Excel Application.
File is attached as example
Please give me any solution.
Thank you so much
Not exactly the X on the application per se, but have you tried using the workbook close event?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hi AmirSoft,
See the attached copy of your workbook. Code follows here:
Ordinary Module Code:
UserForm Code:Please Login or Register to view this content.
ThisWorkBook Code:Please Login or Register to view this content.
LewisPlease Login or Register to view this content.
LJMetzger,
I'll try to copy/paste your code, but earlier today I tried over and over with the beforeclose event, and no matter what I tried, it was still closing. Yes I put a stop, and then stepped through, cancel was set to true, and it simply closed the application anyhow. I thought it was an easy one to answer, but simply could not get the close to cancel no matter what I tried.
P.S. Tried it now, I get the message, but it just closed. Any thoughts on what is going on?
There are no easy answers with Excel.I thought it was an easy one to answer
I had problems too until I moved 'Application.Quit' into Worksheet_BeforeClose().
I suggest you download my file, and see if it works for you. Then try the cut and paste.
Lewis
LJMetzger Thanks
You did it.
Thank You so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks