Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide unnecessary sheets when emailing to others
when I email to other people my worksheet, I don't know how to hide the
unnecessary sheets, so I just let my customers see what they should know. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide unnecessary sheets when emailing to others
Try Format Sheet Hide to hide sheets. They'll be able to unhide
them unless you protect the workbook. - John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide unnecessary sheets when emailing to others
With the sheet you want to hide being the active sheet, Format-Sheet-Hide
-- Regards, Dave "snow" wrote: when I email to other people my worksheet, I don't know how to hide the unnecessary sheets, so I just let my customers see what they should know. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide unnecessary sheets when emailing to others
Hi Snow
You can install my Mail add-in and send only the sheets you want http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl "snow" wrote in message ... when I email to other people my worksheet, I don't know how to hide the unnecessary sheets, so I just let my customers see what they should know. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide unnecessary sheets when emailing to others
Snow
Excel's security is not too robust. Passwords for hiding and protecting data are easily broken. The rule is............if you don't want them to see it, do not send that data enclosed in the file. Copy the sheets for users' viewing into a new workbook and send that to them. Gord Dibben Excel MVP On Fri, 16 Dec 2005 11:21:02 -0800, "snow" wrote: when I email to other people my worksheet, I don't know how to hide the unnecessary sheets, so I just let my customers see what they should know. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide unnecessary sheets when emailing to others
Hi, David:
I tried, but people could still see my sheets when unhide it "David Billigmeier" wrote: With the sheet you want to hide being the active sheet, Format-Sheet-Hide -- Regards, Dave "snow" wrote: when I email to other people my worksheet, I don't know how to hide the unnecessary sheets, so I just let my customers see what they should know. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
hide sheets use data | Excel Worksheet Functions | |||
Hide rows and update fileds in different sheets | Excel Discussion (Misc queries) | |||
macro to hide sheets | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions |