hide unnecessary sheets when emailing to others

S

snow

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.
 
J

John Michl

Try Format > Sheet > Hide to hide sheets. They'll be able to unhide
them unless you protect the workbook.

- John
 
D

David Billigmeier

With the sheet you want to hide being the active sheet, Format->Sheet->Hide
 
G

Gord Dibben

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
 
Top