Printing and emailing query

[dragons_lair]

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

 

[fake_be]

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/EFD168/YI016520882.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?s=c946dcd9ea45554f3b32cdb0345b9ea4&showtopic=201

Good luck,
Tom

 

[dragons_lair]

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

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/EFD168/YI016520882.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?s=c946dcd9ea45554f3b32cdb0345b9ea4&showtopic=201

Good luck,
Tom