Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I created a sales order excel spreadsheet with 997 lines, then I autofilter
down the info I want the other depts to see. (One gets to see the prices, the other dept doesn't) If I just E-mail the worksheet that protects the data, the margins, etc don't transfer and what should print on one page, takes 5 pages. If I E-mail as an attachment to save the print settings, they have access to change the data and view the prices. Any ideas? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi
You can only send the visible cells in the Body or attachments There is code here and also the Add-in can do it for you http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "sewsew8591" wrote in message ... I created a sales order excel spreadsheet with 997 lines, then I autofilter down the info I want the other depts to see. (One gets to see the prices, the other dept doesn't) If I just E-mail the worksheet that protects the data, the margins, etc don't transfer and what should print on one page, takes 5 pages. If I E-mail as an attachment to save the print settings, they have access to change the data and view the prices. Any ideas? |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Printering etc. will deppend on the end users print set up.
They may have different fonts, paper size etc etc Anyway hiden columns can't be changed if the sheet is protected, nor can the filters be changed. On Tue, 11 Jul 2006 18:28:02 +0100, sewsew8591 wrote: I created a sales order excel spreadsheet with 997 lines, then I autofilter down the info I want the other depts to see. (One gets to see the prices, the other dept doesn't) If I just E-mail the worksheet that protects the data, the margins, etc don't transfer and what should print on one page, takes 5 pages. If I E-mail as an attachment to save the print settings, they have access to change the data and view the prices. Any ideas? -- Steve (3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Excel link to data in other worksheet only refreshes one column | Excel Discussion (Misc queries) | |||
How to..use worksheet form and save data to an Excel list | Excel Discussion (Misc queries) |