Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Import - Web Query - Results = Printing Version | Excel Worksheet Functions | |||
Emailing | Excel Discussion (Misc queries) | |||
Emailing | Excel Discussion (Misc queries) | |||
emailing | Excel Worksheet Functions | |||
Excel printing query | Excel Discussion (Misc queries) |