Procedure works only if I click F5 in VBEditor

[AZ-XL]

Hi Friends

I have code that user selects folder and all the xls files in that folder saving as xlsx. I saved this code in Personal workbook to use it frequently. But, when I trigger code it only opens first file in that folder and stops. But when I open VB editor and click F5 (run) it works without problem.
Here is my code:

Please Login or Register  to view this content.

How I can solve this problem. Please help.

Thank you

[BadlySpelledBuoy]

How are you triggering it?

I just tried via Alt+F8 and it works fine for me.

BSB

[romperstomper]

If you are running it using a shortcut key that involves the Shift key, try using a key combination that doesn't require Shift.

[AZ-XL]

If you are running it using a shortcut key that involves the Shift key, try using a key combination that doesn't require Shift.

That is true, I use short cut with shift button.
With Alt+F8 there is no problem.

But I changed Ctrl+Shift+W to Ctrl+w it worked but another problem occurred. After converting files to xlsx the selection window does not close.

There is no problem for me to use Alt+F8 to start the process, but it is interesting for me why shortcut creates such problem?

Thank you

[romperstomper]

The Shift issue is a known bug (it relates to using Shift to prevent event code from running when you open a workbook) but I don't know why Ctrl+W would leave a dialog open. Can you put a macro button on your QAT?

[AZ-XL]

The Shift issue is a known bug (it relates to using Shift to prevent event code from running when you open a workbook) but I don't know why Ctrl+W would leave a dialog open. Can you put a macro button on your QAT?

I did not know about that bug.
It is good idea to put to Quick Access

Thank you

Good Luck