Geez.. tat works!Thanks!
Now I have another problem.. haha.
I have some buttons in my original workbook, but when I want to prin
the worksheets, the buttons should not be shown.
How can I copy all the worksheets over to the new workbook withou
copying the buttons
--
Message posted from
http://www.ExcelForum.com