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.
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks