| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding worksheet
Is there any way you can hide a worksheet in a workbook? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding worksheet
Hi, To hide it use Sheets("Sheet1").Visible = False or to prevent someone simply unhiding it use Sheets("Sheet1").Visible = xlVeryHidden Mike "Link" wrote: Is there any way you can hide a worksheet in a workbook? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding worksheet
Do you click on the sheet tab? "Mike H" wrote: Hi, To hide it use Sheets("Sheet1").Visible = False or to prevent someone simply unhiding it use Sheets("Sheet1").Visible = xlVeryHidden Mike "Link" wrote: Is there any way you can hide a worksheet in a workbook? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding worksheet
Hi, It can go as worksheet code. Right click your sheet tab, view code and paste this in and run it Sub HideMe() Sheets("Sheet1").Visible = xlVeryHidden End Sub Mike "Link" wrote: Do you click on the sheet tab? "Mike H" wrote: Hi, To hide it use Sheets("Sheet1").Visible = False or to prevent someone simply unhiding it use Sheets("Sheet1").Visible = xlVeryHidden Mike "Link" wrote: Is there any way you can hide a worksheet in a workbook? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding worksheet
FormatSheetHide if you don't want VBA Gord Dibben MS Excel MVP On Tue, 23 Jun 2009 07:34:01 -0700, Link wrote: Is there any way you can hide a worksheet in a workbook? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding worksheet
after using xlVeryHidden, how would I unhide the sheet in my workbook?
"Mike H" wrote: Hi, To hide it use Sheets("Sheet1").Visible = False or to prevent someone simply unhiding it use Sheets("Sheet1").Visible = xlVeryHidden Mike "Link" wrote: Is there any way you can hide a worksheet in a workbook? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding worksheet
Sheets("Sheet1").Visible = True
Gord Dibben MS Excel MVP On Tue, 28 Jul 2009 08:51:01 -0700, rslaughter5 wrote: after using xlVeryHidden, how would I unhide the sheet in my workbook? "Mike H" wrote: Hi, To hide it use Sheets("Sheet1").Visible = False or to prevent someone simply unhiding it use Sheets("Sheet1").Visible = xlVeryHidden Mike "Link" wrote: Is there any way you can hide a worksheet in a workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding the worksheet | Excel Discussion (Misc queries) | |||
| Hiding a Worksheet | Excel Programming | |||
| Hiding a Worksheet | Excel Programming | |||
| Hiding a Worksheet | Excel Programming | |||
| Hiding a Worksheet | Excel Programming | |||
![Link[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
