Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding worksheets in excel
I do not know how to hide a worksheet in excel, so that even the tab does not show. Can anyone help me out please? TIA:) -- a.j ------------------------------------------------------------------------ a.j's Profile: http://www.excelforum.com/member.php...o&userid=30778 View this thread: http://www.excelforum.com/showthread...hreadid=504441 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding worksheets in excel
Two ways.
1. Select the worksheet then use the menu options Format, Worksheet, Hide. This can be reversed by Format, Worksheet, Unhide and then selecting the worksheet from the dialogue box. 2. In Excel 2003 right click on the TAB, select "View Code". The visual basic editor VBE showing the properties for the worksheet opens. Look for the characteristic "Visible" Change the selection to 0 (Hidden) or 2 (Excel Very Hidden) NB if you use the latter you will need to go back into VBE to "unhide" it. "a.j" wrote: I do not know how to hide a worksheet in excel, so that even the tab does not show. Can anyone help me out please? TIA:) -- a.j ------------------------------------------------------------------------ a.j's Profile: http://www.excelforum.com/member.php...o&userid=30778 View this thread: http://www.excelforum.com/showthread...hreadid=504441 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding worksheets in excel
Phillip-
I had never heard of being able to have Very Hidden option. I tried to do this to a tab, but do not see when the option is to change the visible status. Is there a code you must enter to get this function to work? Also, by making a tab "Very Hidden" will the tab name even show up when you go to the Format/Sheet/Unhide option? Thanks "Philip J Smith" wrote in message ... Two ways. 1. Select the worksheet then use the menu options Format, Worksheet, Hide. This can be reversed by Format, Worksheet, Unhide and then selecting the worksheet from the dialogue box. 2. In Excel 2003 right click on the TAB, select "View Code". The visual basic editor VBE showing the properties for the worksheet opens. Look for the characteristic "Visible" Change the selection to 0 (Hidden) or 2 (Excel Very Hidden) NB if you use the latter you will need to go back into VBE to "unhide" it. "a.j" wrote: I do not know how to hide a worksheet in excel, so that even the tab does not show. Can anyone help me out please? TIA:) -- a.j ------------------------------------------------------------------------ a.j's Profile: http://www.excelforum.com/member.php...o&userid=30778 View this thread: http://www.excelforum.com/showthread...hreadid=504441 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding worksheets in excel
Hi Craig.
Sorry that option seems to be new to Excel 2003. To utilise this facility you will need to go into the Visual Basic editor. 1. Press [Alt] [F11] this will open the Visual Basic Editor. 2. There are a number of windows in this view. The window to the upper left window is titled Project - VBA Project. The current sheet is highlighted. Select the name of the sheet you want to hide or "unhide" The window to the lower left is titled "Properties - name of sheet highlighted" 3 In the lower left window there are two tabs. They present the same details but in a slightly different order. On either tab select on the "Visible" property. A down arrow selector will appear, click on it. Three options are available select the approprate one. The second option ExcelSheetHidden can be accessed from menus - see my first reply below. "Craig" wrote: Phillip- I had never heard of being able to have Very Hidden option. I tried to do this to a tab, but do not see when the option is to change the visible status. Is there a code you must enter to get this function to work? Also, by making a tab "Very Hidden" will the tab name even show up when you go to the Format/Sheet/Unhide option? Thanks "Philip J Smith" wrote in message ... Two ways. 1. Select the worksheet then use the menu options Format, Worksheet, Hide. This can be reversed by Format, Worksheet, Unhide and then selecting the worksheet from the dialogue box. 2. In Excel 2003 right click on the TAB, select "View Code". The visual basic editor VBE showing the properties for the worksheet opens. Look for the characteristic "Visible" Change the selection to 0 (Hidden) or 2 (Excel Very Hidden) NB if you use the latter you will need to go back into VBE to "unhide" it. "a.j" wrote: I do not know how to hide a worksheet in excel, so that even the tab does not show. Can anyone help me out please? TIA:) -- a.j ------------------------------------------------------------------------ a.j's Profile: http://www.excelforum.com/member.php...o&userid=30778 View this thread: http://www.excelforum.com/showthread...hreadid=504441 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding worksheets in excel
Phillip-
Thanks! This is great. I didn't have the properties window up and visible. So that was my problem Thanks again. Craig "Philip J Smith" wrote in message ... Hi Craig. Sorry that option seems to be new to Excel 2003. To utilise this facility you will need to go into the Visual Basic editor. 1. Press [Alt] [F11] this will open the Visual Basic Editor. 2. There are a number of windows in this view. The window to the upper left window is titled Project - VBA Project. The current sheet is highlighted. Select the name of the sheet you want to hide or "unhide" The window to the lower left is titled "Properties - name of sheet highlighted" 3 In the lower left window there are two tabs. They present the same details but in a slightly different order. On either tab select on the "Visible" property. A down arrow selector will appear, click on it. Three options are available select the approprate one. The second option ExcelSheetHidden can be accessed from menus - see my first reply below. "Craig" wrote: Phillip- I had never heard of being able to have Very Hidden option. I tried to do this to a tab, but do not see when the option is to change the visible status. Is there a code you must enter to get this function to work? Also, by making a tab "Very Hidden" will the tab name even show up when you go to the Format/Sheet/Unhide option? Thanks "Philip J Smith" wrote in message ... Two ways. 1. Select the worksheet then use the menu options Format, Worksheet, Hide. This can be reversed by Format, Worksheet, Unhide and then selecting the worksheet from the dialogue box. 2. In Excel 2003 right click on the TAB, select "View Code". The visual basic editor VBE showing the properties for the worksheet opens. Look for the characteristic "Visible" Change the selection to 0 (Hidden) or 2 (Excel Very Hidden) NB if you use the latter you will need to go back into VBE to "unhide" it. "a.j" wrote: I do not know how to hide a worksheet in excel, so that even the tab does not show. Can anyone help me out please? TIA:) -- a.j ------------------------------------------------------------------------ a.j's Profile: http://www.excelforum.com/member.php...o&userid=30778 View this thread: http://www.excelforum.com/showthread...hreadid=504441 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding worksheets in excel
Once a worksheet is hidden, however, is there any way to still access it via a hyperlink in an unhidden worksheet in the same workbook? -- TheChris ------------------------------------------------------------------------ TheChris's Profile: http://www.excelforum.com/member.php...o&userid=31077 View this thread: http://www.excelforum.com/showthread...hreadid=504441 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how to use input formula from several worksheets in excel? | Excel Worksheet Functions | |||
Appending excel worksheets | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Want Excel to break links between worksheets in same file | Excel Worksheet Functions |