Not sure why you'd need a ChDir command. I have Excel code  that saves to
many and varied directories without needing ChDir.

To stop the messages when deleting the sheets you'll need to turn them off
temporarily.

Application.DisplayAlerts = False

then delete the sheets, then

Application.DisplayAlerts = True

to get the alerts back on again.