Three ways I could suggest you approach this:
1. Use a file to signal Python that VBA has concluded its work
To do that, have your VBA script create a blank file (could be .xlsx)
import os.path
import time
"""
First block of code here
"""
while os.path.isfile('signal.xlsx') == False:
time.sleep(10)
"""
Second block of code here
"""
2. Calculate how long it takes for your VBA script to run
If you're having your script alter some aspects of a worksheet, do a run with a shorter version, calculate how long it takes and then multiply the run time by the total iterations it will have to run through.
Have Python wait those many seconds before running the following blocks.
import time
time.sleep(seconds)
3. Use the Python Scheduler
You could also use the Schedule project to run your script at a given time if you think it's a safer play to run it during the evening, for instance.
I'd refer you to https://pypi.org/project/schedule/ as it has a very straight forward usage example.