Open a specific worksheet in workbook
 

I have a workbook that contains several worksheets. I need to send thi
out to different departments but I would like for each department t
view only their information and keep the other worksheets hidden. T
take it one step further, then have it set for one certain departmen
to view all. Is this possible?
Thank you in advance for your expert advise and help with thi
problem.
Le

--
lee
-----------------------------------------------------------------------
leem's Profile: http://www.excelforum.com/member.php...fo&userid=1602
View this thread: http://www.excelforum.com/showthread.php?threadid=37769

Open a specific worksheet in workbook
 

Why don't you record a macro to hide all sheets but one, save the
workbook and email. Then go to the next sheet to be displayed (hide
all others) and repeat for each sheet?

Open a specific worksheet in workbook
 

How are you going to identify each department. Based on sme logi
info....? If you can do that, the rest would be easy.

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=37769