In all my Excel projects if any macro works more then just a moment I use Progress Bar so user can see status of the long operation and estimated time of completion as well as user can cancel the operation.
I'm experienced VBA developer focused on creating of advanced business tools for Microsoft Excel. Also I work with other Microsoft Office applications such as Word, Outlook, PowerPoint, Access, Visio. And I'm not just a developer, I'm experienced business consultant with a Master's degree in project management and a Bachelor's degree in finance. Worked as IT project manager and CIO in manufacturing, retail, real estate development and marketing companies with from 15 to 20000 employees.