Thanks for the links, i used Chip's method.

The reason i cant just right click and remove them is because im no
going to be running this spreadsheet. It is going to be run about 8
15 times a day. I dont want to make the people running the macro t
have to manually delete them to make the file size 50% smaller.

Anyways, thanks again for the link

--
Message posted from http://www.ExcelForum.com