Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

hide unnecessary sheets when emailing to others

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
snow - 16 Dec 2005 19:21 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.