heritagedoorchris
New Member
- Joined
- Jul 6, 2005
- Messages
- 16
I have searched the site and am unable to find a solution. I have two groups of options buttons created from the forms toolbar. There are 2 options in one group and 5 options in the other. Based upon the value concatenation of these two control cells I am running if/or/then/elseif code to hide and unhide certain rows of data. Essentially my code is unprotecting the sheet, turning off screen update, performing 4 if then statements, ending the IF, reapplying screen update and reprotecting the sheet. I have tried running this as a Private Worksheet Subroutine: Calculate, SelectionChange, and Change. I can not get this to hide my rows. I really would not like to link these to Control box option buttons since I would need 10 of them to accomplish this task. Any suggestions would be greatly appreciated.