Homer Simpson yelling at the microwave: Cook faster!!!!!

Glad you got it working.

Otto Moehrbach wrote:

I couldn't wait till morning. It works just like you said. Thanks again.
Otto
"Dave Peterson" wrote in message
...
Try removing the shift key from the shortcut.

If you hold the shift down while opening a workbook, the auto_open and
workbook_open procedures won't run. When the shift key is part of the
shortcut
key combination, it can confuse excel enough to stop the macro that's
running.

Otto Moehrbach wrote:

Excel XP & Win XP
I took a macro to loop through all the files in a folder from Debra's
site:
http://www.contextures.com/xlfaqMac.html#LoopBooks

I tested it without any changes and it worked fine.

I assigned a key combination, Ctrl-Shift-P, and then Ctrl-Shift-B, in
turn,
to the macro. When I ran the macro from the key combination, the macro
ran
but would not proceed beyond opening the first file. No error messages.
Nothing.

What is happening?

Thanks for your time. Otto

--

Dave Peterson

--

Dave Peterson