| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide excel sheets
I want to hide worksheet in excel worksheet using combo-box.
This combobox has got 2 options : "YES" and "NO" For "NO" this will hide the worksheet and vice versa. Please help, how it can be configured. Sunil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide excel sheets
Hi,
Try this, the text for 'Yes Private Sub ComboBox1_Click() If UCase(ComboBox1.Text) = "YES" Then Sheets("Sheet1").Visible = False Else Sheets("Sheet1").Visible = True End If End Sub Mike "Sunil Sagar" wrote: I want to hide worksheet in excel worksheet using combo-box. This combobox has got 2 options : "YES" and "NO" For "NO" this will hide the worksheet and vice versa. Please help, how it can be configured. Sunil |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide excel sheets
I meant to say
Try this, the text for 'YES' is meant to be upper case "Mike H" wrote: Hi, Try this, the text for 'Yes Private Sub ComboBox1_Click() If UCase(ComboBox1.Text) = "YES" Then Sheets("Sheet1").Visible = False Else Sheets("Sheet1").Visible = True End If End Sub Mike "Sunil Sagar" wrote: I want to hide worksheet in excel worksheet using combo-box. This combobox has got 2 options : "YES" and "NO" For "NO" this will hide the worksheet and vice versa. Please help, how it can be configured. Sunil |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide excel sheets
Great !!
thanks for the prompt reply Mike, It worked !! "Mike H" wrote: I meant to say Try this, the text for 'YES' is meant to be upper case "Mike H" wrote: Hi, Try this, the text for 'Yes Private Sub ComboBox1_Click() If UCase(ComboBox1.Text) = "YES" Then Sheets("Sheet1").Visible = False Else Sheets("Sheet1").Visible = True End If End Sub Mike "Sunil Sagar" wrote: I want to hide worksheet in excel worksheet using combo-box. This combobox has got 2 options : "YES" and "NO" For "NO" this will hide the worksheet and vice versa. Please help, how it can be configured. Sunil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide a macros/functions from excel sheets | Excel Discussion (Misc queries) | |||
| Hide all sheets but selected sheets - an example | Excel Programming | |||
| Excel password but cant hide the sheets before entering password | Excel Programming | |||
| How to hide sheets and VBA code in my Excel workbook? | Excel Programming | |||
| How to hide sheets and VBA code in my Excel workbook? | Excel Programming | |||
Linear Mode
