On previous versions if you put E&xit within the Caption property of a
command button, when you ran the code you could press Alt + X as a shortcut
to close the form. Does anyone know how to do this in Excel 2007 as this way
doesnt work.

Thanks

I don't think that is the way it has ever worked. Perhaps you are thinking
of VB6, which does work this way. In Excel/VBA, you've always had to use the
Accelerator property to assign a keystroke to a control.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Richard" wrote in message
...
On previous versions if you put E&xit within the Caption property of a
command button, when you ran the code you could press Alt + X as a
shortcut
to close the form. Does anyone know how to do this in Excel 2007 as this
way
doesnt work.

Thanks