Updating Values (don't want to be prompted)
 

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

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

Updating Values (don't want to be prompted)
 

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/

Updating Values (don't want to be prompted)
 

can I do this with code? Would turning off the appevents work?

The file is generated by code and is all automated so doing it that wa
might be difficult? I don't know. But would turning off appevents i
files that say don't have the referenced worksheet work

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