Sending only part of a workbook thru emai
 

I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me.
In sheet 3 I pull data from the first two sheet into a predefined format
that is organized into a comprehensive schedule of activities .

My question is this. I want to be able to send the information from sheet 3
to people thru email but I don't want to send the whole workbook that
contains my calculations/formulas and other data they don't need to see that
is in sheets 1 and 2. Is there a way to get the data from sheet sent without
the rest of the workbook?
Thanks
Carl

Sending only part of a workbook thru emai
 

You could just right-click on the sheet tab and "move or copy".

Copty to a new workbook.

Save that and send it.

Alternative is Ron de Bruin's site for individual sendmail code methods.

http://www.rondebruin.nl/sendmail.htm

If you download his SENDMAIL add-in you will have all the options at your
fingertips.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 08:39:00 -0800, carl43m
wrote:

I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me.
In sheet 3 I pull data from the first two sheet into a predefined format
that is organized into a comprehensive schedule of activities .

My question is this. I want to be able to send the information from sheet 3
to people thru email but I don't want to send the whole workbook that
contains my calculations/formulas and other data they don't need to see that
is in sheets 1 and 2. Is there a way to get the data from sheet sent without
the rest of the workbook?
Thanks
Carl

Sending only part of a workbook thru emai
 

Because sheet three is driven by calculations in other sheets--after I copy
it to a new workbook it asks if I want links updated? If i just say no and
send the new workbook out to people will they get that same message also when
they try to open it?
Carl

"Gord Dibben" wrote:

You could just right-click on the sheet tab and "move or copy".

Copty to a new workbook.

Save that and send it.

Alternative is Ron de Bruin's site for individual sendmail code methods.

http://www.rondebruin.nl/sendmail.htm

If you download his SENDMAIL add-in you will have all the options at your
fingertips.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 08:39:00 -0800, carl43m
wrote:

I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me.
In sheet 3 I pull data from the first two sheet into a predefined format
that is organized into a comprehensive schedule of activities .

My question is this. I want to be able to send the information from sheet 3
to people thru email but I don't want to send the whole workbook that
contains my calculations/formulas and other data they don't need to see that
is in sheets 1 and 2. Is there a way to get the data from sheet sent without
the rest of the workbook?
Thanks
Carl

Sending only part of a workbook thru emai
 

Hi carl43m

There is a example in my code to change the formulas to values
There is a option in my add-in to do this also

If you want to do it manual see
http://www.rondebruin.nl/values.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"carl43m" wrote in message ...
Because sheet three is driven by calculations in other sheets--after I copy
it to a new workbook it asks if I want links updated? If i just say no and
send the new workbook out to people will they get that same message also when
they try to open it?
Carl

"Gord Dibben" wrote:

You could just right-click on the sheet tab and "move or copy".

Copty to a new workbook.

Save that and send it.

Alternative is Ron de Bruin's site for individual sendmail code methods.

http://www.rondebruin.nl/sendmail.htm

If you download his SENDMAIL add-in you will have all the options at your
fingertips.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 08:39:00 -0800, carl43m
wrote:

I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me.
In sheet 3 I pull data from the first two sheet into a predefined format
that is organized into a comprehensive schedule of activities .

My question is this. I want to be able to send the information from sheet 3
to people thru email but I don't want to send the whole workbook that
contains my calculations/formulas and other data they don't need to see that
is in sheets 1 and 2. Is there a way to get the data from sheet sent without
the rest of the workbook?
Thanks
Carl

Sending only part of a workbook thru emai
 

After copying to the new book, select all cells and EditCopy

Then EditPaste SpecialValuesOKEsc.

Now save and send.


Gord

On Thu, 14 Dec 2006 11:43:02 -0800, carl43m
wrote:

Because sheet three is driven by calculations in other sheets--after I copy
it to a new workbook it asks if I want links updated? If i just say no and
send the new workbook out to people will they get that same message also when
they try to open it?
Carl

"Gord Dibben" wrote:

You could just right-click on the sheet tab and "move or copy".

Copty to a new workbook.

Save that and send it.

Alternative is Ron de Bruin's site for individual sendmail code methods.

http://www.rondebruin.nl/sendmail.htm

If you download his SENDMAIL add-in you will have all the options at your
fingertips.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 08:39:00 -0800, carl43m
wrote:

I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me.
In sheet 3 I pull data from the first two sheet into a predefined format
that is organized into a comprehensive schedule of activities .

My question is this. I want to be able to send the information from sheet 3
to people thru email but I don't want to send the whole workbook that
contains my calculations/formulas and other data they don't need to see that
is in sheets 1 and 2. Is there a way to get the data from sheet sent without
the rest of the workbook?
Thanks
Carl

Sending only part of a workbook thru emai
 

Thanks!

"Gord Dibben" wrote:

After copying to the new book, select all cells and EditCopy

Then EditPaste SpecialValuesOKEsc.

Now save and send.


Gord

On Thu, 14 Dec 2006 11:43:02 -0800, carl43m
wrote:

Because sheet three is driven by calculations in other sheets--after I copy
it to a new workbook it asks if I want links updated? If i just say no and
send the new workbook out to people will they get that same message also when
they try to open it?
Carl

"Gord Dibben" wrote:

You could just right-click on the sheet tab and "move or copy".

Copty to a new workbook.

Save that and send it.

Alternative is Ron de Bruin's site for individual sendmail code methods.

http://www.rondebruin.nl/sendmail.htm

If you download his SENDMAIL add-in you will have all the options at your
fingertips.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 08:39:00 -0800, carl43m
wrote:

I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me.
In sheet 3 I pull data from the first two sheet into a predefined format
that is organized into a comprehensive schedule of activities .

My question is this. I want to be able to send the information from sheet 3
to people thru email but I don't want to send the whole workbook that
contains my calculations/formulas and other data they don't need to see that
is in sheets 1 and 2. Is there a way to get the data from sheet sent without
the rest of the workbook?
Thanks
Carl

Sending only part of a workbook thru emai
 

You're welcome and sorry for not thinking of that first time around.

You did say sheet3 "pulls" data from the other 2 sheets.


Gord

On Thu, 14 Dec 2006 13:53:01 -0800, carl43m
wrote:

Thanks!

"Gord Dibben" wrote:

After copying to the new book, select all cells and EditCopy

Then EditPaste SpecialValuesOKEsc.

Now save and send.


Gord

On Thu, 14 Dec 2006 11:43:02 -0800, carl43m
wrote:

Because sheet three is driven by calculations in other sheets--after I copy
it to a new workbook it asks if I want links updated? If i just say no and
send the new workbook out to people will they get that same message also when
they try to open it?
Carl

"Gord Dibben" wrote:

You could just right-click on the sheet tab and "move or copy".

Copty to a new workbook.

Save that and send it.

Alternative is Ron de Bruin's site for individual sendmail code methods.

http://www.rondebruin.nl/sendmail.htm

If you download his SENDMAIL add-in you will have all the options at your
fingertips.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 08:39:00 -0800, carl43m
wrote:

I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me.
In sheet 3 I pull data from the first two sheet into a predefined format
that is organized into a comprehensive schedule of activities .

My question is this. I want to be able to send the information from sheet 3
to people thru email but I don't want to send the whole workbook that
contains my calculations/formulas and other data they don't need to see that
is in sheets 1 and 2. Is there a way to get the data from sheet sent without
the rest of the workbook?
Thanks
Carl





Gord Dibben MS Excel MVP