For a few different options see
http://www.mrexcel.com/board2/viewto...?p=88129#88129

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?TmVpbCBIb3BraW5zb24=?=" <Neil
says...
I have written a macro which takes a minute or so to run. I want to set up a
progress bar so the user can see something happening and knows the program
hasn't crashed. How do I do this?