You're welcome! Thanks for letting me know that it worked.

A new Personal.xls would be created if you record a macro, and choose to
store it in the Personal Macro Workbook. Then, save the Personal.xls
workbook, if prompted, when you close Excel.

Kinjalip wrote:
I was able to copy and paste special as you mentioned. This worked now the
file size is 25k, like it should be. Thanks

Do you know if you can remove the personal.xls and if so, when you restart
Excel, is it recreated as default as in Word with the Normal.dot?

Thanks again!!!!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html