Hello! I created a master workbook for my job that automatically opens multiple excel tracking sheets, formats the data, copies, pastes into master, moves the files to a completed folder so on and so forth. Seeing as these are work computers it takes anywhere from 3-10 minutes depending on the amount of files. I would like a progress bar that shows a running percent bar with a percent completed and with text that states what the book is currently doing. I understand I would have to create a userform but how do you call the userform when the first macro begins/keep updating the userform on different macros. Basically the sheet consists of something like 6 macros that when one finishes it calls the next. Thanks. Let me know if this is not exnough description.