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.
John Michl - 16 Dec 2005 19:24 GMT
Try Format > Sheet > Hide to hide sheets. They'll be able to unhide
them unless you protect the workbook.
- John
David Billigmeier - 16 Dec 2005 19:27 GMT
With the sheet you want to hide being the active sheet, Format->Sheet->Hide

Signature
Regards,
Dave
> 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.
snow - 17 Dec 2005 01:46 GMT
Hi, David:
I tried, but people could still see my sheets when unhide it
> With the sheet you want to hide being the active sheet, Format->Sheet->Hide
>
> > 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.
Ron de Bruin - 16 Dec 2005 21:54 GMT
Hi Snow
You can install my Mail add-in and send only the sheets you want
http://www.rondebruin.nl/mail/add-in.htm

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
> 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.
Gord Dibben - 16 Dec 2005 23:14 GMT
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
>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.