Hi ericbarta,

The macro works except for the error message.

I have already tested with Application.DisplayAlert or ScreenUdating. both seems does not work to remove the error message.