R
Rutgers_Excels
Hi!
I have set up a database in excel using forms and worksheets. On on
worksheet (sheet30), there are 6 checkboxes. A button is used to ope
this worksheet so that people can load their data into the database.
The checkboxes are used to hide and unhide rows when clicked.
Here's the problem...Each time I open this worksheet, I would like th
checkboxes to be unchecked (false) and all rows to be in the hidde
position. I thought that the code below would work fine,
Sheet30.CheckBox1.Value = False
Sheet30.CheckBox2.Value = False
Sheet30.CheckBox3.Value = False
Sheet30.CheckBox4.Value = False
Sheet30.CheckBox5.Value = False
Sheet30.CheckBox6.Value = False
...but it seems to only uncheck one of the boxes. If I close th
worksheet and try it again it will uncheck another box (ie one at
time).
If it makes a difference, that piece of code is used within a large
block of code which does other things when the worksheet is open.
Any help would be appreciated
I have set up a database in excel using forms and worksheets. On on
worksheet (sheet30), there are 6 checkboxes. A button is used to ope
this worksheet so that people can load their data into the database.
The checkboxes are used to hide and unhide rows when clicked.
Here's the problem...Each time I open this worksheet, I would like th
checkboxes to be unchecked (false) and all rows to be in the hidde
position. I thought that the code below would work fine,
Sheet30.CheckBox1.Value = False
Sheet30.CheckBox2.Value = False
Sheet30.CheckBox3.Value = False
Sheet30.CheckBox4.Value = False
Sheet30.CheckBox5.Value = False
Sheet30.CheckBox6.Value = False
...but it seems to only uncheck one of the boxes. If I close th
worksheet and try it again it will uncheck another box (ie one at
time).
If it makes a difference, that piece of code is used within a large
block of code which does other things when the worksheet is open.
Any help would be appreciated