| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding a Worksheet
I've got a spreadsheet that I designed at work. On it, it lists certain statistical numbers by month. I have another workbook that has a worksheet for each month detailing the numbers per salesman. What I want to do is combine the two books (which I know how to do) and link to the detailed worksheets from the one overall worksheet (which I also know how to do). The question I ask is this: Is there any way to make the tabs for the detailed worksheets invisible, so they can only be loaded by clicking the hyperlink in the overall sheet? I tried using Format - Sheet - Hide, which does hide the tabs, but then the hyperlinks won't work anymore. -- TheChris ------------------------------------------------------------------------ TheChris's Profile: http://www.excelforum.com/member.php...o&userid=31077 View this thread: http://www.excelforum.com/showthread...hreadid=507737 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding a Worksheet
"TheChris" wrote in message ... I've got a spreadsheet that I designed at work. On it, it lists certain statistical numbers by month. I have another workbook that has a worksheet for each month detailing the numbers per salesman. What I want to do is combine the two books (which I know how to do) and link to the detailed worksheets from the one overall worksheet (which I also know how to do). The question I ask is this: Is there any way to make the tabs for the detailed worksheets invisible, so they can only be loaded by clicking the hyperlink in the overall sheet? I tried using Format - Sheet - Hide, which does hide the tabs, but then the hyperlinks won't work anymore. -- TheChris ------------------------------------------------------------------------ TheChris's Profile: http://www.excelforum.com/member.php...o&userid=31077 View this thread: http://www.excelforum.com/showthread...hreadid=507737 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding a Worksheet
Sorry, I don't see anything in your reply. -- TheChris ------------------------------------------------------------------------ TheChris's Profile: http://www.excelforum.com/member.php...o&userid=31077 View this thread: http://www.excelforum.com/showthread...hreadid=507737 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA code to Add data to exsiting worksheet | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Protected worksheet, showing and hiding Grouped detail | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Linear Mode
