Updating Values (don't want to be prompted)

  • Thread starter Thread starter RPIJG
  • Start date Start date
R

RPIJG

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
 
With your workbook open to the worksheet you wish to copy....

Open a blank workbook via File>New>Workbook.

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

Switch to blank workbook and Paste Special>Values.

Delete any blank worksheets from new workbook and File>Save As.

Send this file to your user.

Gord Dibben Excel MVP
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Template with Updated Values Each Time 0
copying a template sheet and inputting a formula into another sheetthat references the new sheet 1
Excel Move or Copy Stopped Working? 0
How to reference a cell from anther workbook without opening it 0
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Find a value in a sheet and replace it with another value if it matches 8
How to prevent a graph update 2

Back
Top