Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
snow
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
snow
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In 3 active sheets in wkbk, determine& display the # of sheets that have data wrpalmer Excel Discussion (Misc queries) 1 November 4th 05 03:01 PM
hide sheets use data j2thea Excel Worksheet Functions 3 November 3rd 05 10:23 PM
Hide rows and update fileds in different sheets Carlos Canstatt Excel Discussion (Misc queries) 1 November 2nd 05 03:47 AM
macro to hide sheets ditchy Excel Discussion (Misc queries) 8 May 2nd 05 02:21 AM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 06:49 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"