Macro
Posted by Nancy on December 18, 2001 10:57 AM
Hi!
> I am trying to hide cells in one of my spreadsheets. Originally, I wanted to use two advanced filters on one worksheet, but that didn't work. I am
> trying to set a button that way so when I push it, some of the cells disappear according to my restrictions. If you could help me out with that, i would appreciate it!!
> Thank you
> Nancy Suchowski
Posted by Mike Grady on December 18, 2001 11:28 AM
Try recording macros with you formatting the cells to each set of your restrictions. Then on the forms menu, you can place buttons on the screen and link it to each of your macros. Maybe one macro to hide them and another to unhide. Hope this helps....
Posted by Nancy on December 18, 2001 11:31 AM
Thank you
I will try that
