Printing and emailing query
 

Currently I have 3 worksheets in a workbook, worksheet one is the product
list and prices, worksheet 2 is the where the products for the quote is
slected and worksheet 3 is the letter to the customer. The workbook is set up
as a template to force the user to create a new file every time it is
accessed. I want to be able to stop anyone from sending the entire workbook
to the customer either in printed form or emailed. I only want them to be
able to send the letter worksheet. Is this possible in excel, any ideas would
be most welcome

Thanks

--
Dragonette

Printing and emailing query
 

Hi Dragonette,

First of all i don't have a way that users wont mail the workbook but
there are some 'proctections' you can build in the sheet;

First of all u need to hide the 'price' sheets and passwordprotect the
sheet and workbook so that the 'customers' wont be able to see the
information. More information here http://www.bettersolutions.com/excel...I016520882.htm

On the other hand you can create a function to mail a sheet (and not
the workbook) to customers. Users prefer a fast and simpel way to
communicate so there is a good probability that they use a fast
function instead of attaching the workbook...
The function is available via VBA see
http://xlvba.3.forumer.com/index.php...howt opic=201

Good luck,
Tom

On 29 mei, 05:26, dragons_lair
wrote:
Currently I have 3 worksheets in a workbook, worksheet one is the product
list and prices, worksheet 2 is the where the products for the quote is
slected and worksheet 3 is the letter to the customer. The workbook is set up
as a template to force the user to create a new file every time it is
accessed. I want to be able to stop anyone from sending the entire workbook
to the customer either in printed form or emailed. I only want them to be
able to send the letter worksheet. Is this possible in excel, any ideas would
be most welcome

Thanks

--
Dragonette

Printing and emailing query
 

Thanks Tom, I'll give it a go
--
Dragonette


"fake_be" wrote:

Hi Dragonette,

First of all i don't have a way that users wont mail the workbook but
there are some 'proctections' you can build in the sheet;

First of all u need to hide the 'price' sheets and passwordprotect the
sheet and workbook so that the 'customers' wont be able to see the
information. More information here http://www.bettersolutions.com/excel...I016520882.htm

On the other hand you can create a function to mail a sheet (and not
the workbook) to customers. Users prefer a fast and simpel way to
communicate so there is a good probability that they use a fast
function instead of attaching the workbook...
The function is available via VBA see
http://xlvba.3.forumer.com/index.php...howt opic=201

Good luck,
Tom

On 29 mei, 05:26, dragons_lair
wrote:
Currently I have 3 worksheets in a workbook, worksheet one is the product
list and prices, worksheet 2 is the where the products for the quote is
slected and worksheet 3 is the letter to the customer. The workbook is set up
as a template to force the user to create a new file every time it is
accessed. I want to be able to stop anyone from sending the entire workbook
to the customer either in printed form or emailed. I only want them to be
able to send the letter worksheet. Is this possible in excel, any ideas would
be most welcome

Thanks

--
Dragonette