Problem with short-cut key combination
 

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

Problem with short-cut key combination
 

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

Problem with short-cut key combination
 

Thanks Dave. That sounds like the cause. I'll try it in the morning. 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

Problem with short-cut key combination
 

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

Problem with short-cut key combination
 

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