Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Workbook on Specific Worksheet | Excel Discussion (Misc queries) | |||
Open Workbook to Specific Worksheet? | Excel Discussion (Misc queries) | |||
How to open a workbook on a specific worksheet. | Excel Worksheet Functions | |||
Open workbook to specific worksheet | Excel Discussion (Misc queries) | |||
On open workbook go to a specific worksheet | Excel Programming |