Stuck in a Sub Loop

  • Thread starter Thread starter robzrob
  • Start date Start date
R

robzrob

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





- Show quoted text -
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get pi to appear in a message box when coded using VBA 0
Excel Providing user message when RED X clicked & properly closing application. 2
Collapsing all groups 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
unprotect password in VBA view 1
Macro for Copying 9
Error moving from 2003 to 2007 3
Can't unshare workbook 7

Back
Top