For the longer macros in my PCF I've incorporated a series of loading pages which simulate a progress bar (courtesy of Daniel Tonks TSU7500 PCF), the last page of which lets the user know the macro has completed and that they're being taken to the main page for the particular activity. The header and messages above and below the progress bar are customized for each activity of course. To see my loading pages in action feel free to download my PCF via the link in my signature area below.