LinkBack URL
About LinkBacks
Hey-
I need to create 2 option buttons one that shows cells F3 and G3 all the way down and then another one that hides F3 and G3 and down?
Coding suggestions?
Hey-
I need to create 2 option buttons one that shows cells F3 and G3 all the way down and then another one that hides F3 and G3 and down?
Coding suggestions?
DoubleA,
Considering that is not possible to Hide a cells range, i just make the trick code above that paint the text in white, so the text become "invisible", and the other button that paint the text in black.
Hope that can help:
Please Login or Register to view this content.
Another way would be to move the contents of the cells to a hidden sheet and then moving them back with the other button.
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
Like this:
Mind you, you would need to add a sheet with the name "Hidden Sheet" and hide it.Please Login or Register to view this content.
Small change in case you have empty cells in the middle:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks