Ok Here is an update,
I left your code in place and made changes accordingly. You really dont need to select ,activate or unhide a sheet to work with it. So you will be able to see how I got around those issues.
Some of the font in one part of the script I took out because i'm running 2003 you can put them back in your orginal workbook.
Keep me posted as to what works and needs addressed.
Bookmarks