|First, before posting code in this forum, please click on the blue Line at the bottom of this post and read the instructions found via that link.|
Second, VBA code gets "confused" when you try to access a range after Activating a different workbook/worksheet from the one that the code resides in.
However, rarely do you have Select (or even Activate) an object in order to perform a VBA action on it.
can be written as single line:
Finally, since it doesn't appear that your code Opens the "Cash flow - paym. in advance.xls" workbook, I'm not sure I understand why you use ChDir and mypath.
If the workbook is already open when you run this code, I think that this should work for you:
Private Sub CommandButton5_Click()
With Workbooks("Cash flow - paym. in advance.xls"). _
Worksheets("Input - DISBURSEMENT").Range("c21:c22")
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.