With your workbook open to the worksheet you wish to copy....

Open a blank workbook via FileNewWorkbook.

Switch to the original and CRTL + A to select cells and Copy.

Switch to blank workbook and Paste SpecialValues.

Delete any blank worksheets from new workbook and FileSave As.

Send this file to your user.

Gord Dibben Excel MVP



On Tue, 6 Jul 2004 15:05:11 -0500, RPIJG
wrote:

When I save a sheet from my workbook into a file that I email I only
copy one of the worksheets which tries to reference data from a
different worksheet(in the main template), this is just an aesthetic
question, but how can I make it so that it doesn't ask if the user
wants to try and update the references?


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