Hello People. Sorry to bother you. I'm stuck in a Sub macro, can't
close the workbook, can't select or change anything at all in the VBA
window. Tried to close workbook, clicking X and Alt+F4, tried to
close VBA window, nothing. I've searched this site and can only find
one suggestion: Esc. But that doesn't work either on the workbook
itself or the VBA window.

It might help for you to post your code.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"robzrob" wrote in message
...
Hello People. Sorry to bother you. I'm stuck in a Sub macro, can't
close the workbook, can't select or change anything at all in the VBA
window. Tried to close workbook, clicking X and Alt+F4, tried to
close VBA window, nothing. I've searched this site and can only find
one suggestion: Esc. But that doesn't work either on the workbook
itself or the VBA window.

On Jul 19, 11:19*pm, "Don Guillett" wrote:
It might help for you to post your code.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"robzrob" wrote in message

...



Hello People. *Sorry to bother you. *I'm stuck in a Sub macro, can't
close the workbook, can't select or change anything at all in the VBA
window. *Tried to close workbook, clicking X and Alt+F4, tried to
close VBA window, nothing. *I've searched this site and can only find
one suggestion: Esc. *But that doesn't work either on the workbook
itself or the VBA window.- Hide quoted text -

- Show quoted text -

The VBA window won't let me copy it, but I think this is the
significant line (I didn't put it in and I don't know how it got
there):

Application.Run "LeaveRecord.xls!Demo"

LeaveRecord is the workbook, Demo is the macro, ie I've somehow got a
'Run Demo' statement within the macro 'Demo' itself.

CTRL + Break


Gord Dibben MS Excel MVP

On Sat, 19 Jul 2008 15:04:41 -0700 (PDT), robzrob wrote:

Hello People. Sorry to bother you. I'm stuck in a Sub macro, can't
close the workbook, can't select or change anything at all in the VBA
window. Tried to close workbook, clicking X and Alt+F4, tried to
close VBA window, nothing. I've searched this site and can only find
one suggestion: Esc. But that doesn't work either on the workbook
itself or the VBA window.

On Jul 19, 11:31*pm, Gord Dibben <gorddibbATshawDOTca wrote:
CTRL + Break

Gord Dibben *MS Excel MVP



On Sat, 19 Jul 2008 15:04:41 -0700 (PDT), robzrob wrote:
Hello People. *Sorry to bother you. *I'm stuck in a Sub macro, can't
close the workbook, can't select or change anything at all in the VBA
window. *Tried to close workbook, clicking X and Alt+F4, tried to
close VBA window, nothing. *I've searched this site and can only find
one suggestion: Esc. *But that doesn't work either on the workbook
itself or the VBA window.- Hide quoted text -

- Show quoted text -

Thanks, Gord.