You don't, Bil. But you can try something like this: http://vbaexpress.com/kb/getarticle.php?kb_id=73
Put a button on your toolbar for it, or you could place it in the
Workbook_Save or Workbook_Close or something.
Change the range from ("A1:A10") to ("A:IV") to make it work on the entire
worksheet.
************
Anne Troy www.OfficeArticles.com
