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

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

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

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