Programming Help

Web Development



What's Here?

  • Members: 132,249
  • Replies: 470,911
  • Topics: 72,988
  • Snippets: 2,540
  • Tutorials: 665
  • Total Online: 1,133
  • Members: 84
  • Guests: 1,049

Who's Online?

Welcome to Dream.In.Code
Getting VB Help is Easy!

Join 132,249 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,133 people online right now. Registration is fast and FREE... Join Now!




Hide a spreadsheet based on a checkbox value

 
 Reply to this topicStart new topic

Hide a spreadsheet based on a checkbox value
arumugam_excel
post 18 Feb, 2008 - 02:48 AM
Post #1


New D.I.C Head

*
Joined: 18 Feb, 2008
Posts: 1
Private Sub CheckBox10_Click()

If (CheckBox10 = 0) Then
Sheet6.Visible = False
Else
If (CheckBox10 = 1) Then
Sheet6.Visible = True
End If
End If
End Sub

I want to hide a excel spreadsheet based on the value of a checkbox in another spreadsheet. This code is not wotking. Please help.
User is offlineProfile CardPM

Go to the top of the page

Nayana
post 18 Feb, 2008 - 03:04 AM
Post #2


DIC Hawk - 나야나 नयन:

Group Icon
Joined: 14 Nov, 2007
Posts: 824



Thanked 5 times

Dream Kudos: 175
My Contributions
I don't have Excel.

But have you tried
CODE

Sheet6.Hide
...
Sheet6.Show

?
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/21/08 10:29PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live VB Help!

VB Tutorials

Reference Sheets

VB Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month