I have a workbook where I select a file to open, from a list on my
worksheet, and then I press a command button to open the file selected.
However when selecting the file, a calculation takes place and if I
press the command button before the calculation is finished, I get an
error message. If I could get about a 5 second pause after pressing
the command button, the calculation will then be finished before the
macro runs.

How do I do this?