Great, that will work. I found another method, but it's more complicated
that I require for this project.
Thanks,
D.S.
"Chip Pearson" wrote in message
...
DS,
You can use the QueryClose event procedure to catch the form's
closing via the 'X' button.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"D.S." wrote in message
...
I would like to prevent the user from closing a userform by
clicking the 'X'
on the right side of the titlebar. I need to force closure by
using a
command button, and running an exit procedure. Is there a
property setting
that will prevent this / or run the exit procedure when the 'X'
is clicked?
D.S.