Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Import - Web Query - Results = Printing Version Mark Excel Worksheet Functions 0 March 28th 07 02:51 AM
Emailing momotaro Excel Discussion (Misc queries) 1 March 21st 06 10:12 PM
Emailing lsherman22 Excel Discussion (Misc queries) 0 January 12th 06 08:35 PM
emailing IanH Excel Worksheet Functions 4 June 1st 05 09:25 PM
Excel printing query Linda Excel Discussion (Misc queries) 2 April 24th 05 11:56 PM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"