Hi
I want to build an interactive pop up box where the user will have to enter one of three words; Haca, Maca or Daca.
and based on that i want to build a macro where if daca is written in the box coulmns b to m are ungrouped only. if maca is written columns n to v are ungrouped and if haca is typed in w to ac are ungrouped only. so at any one time only one part is ungrouped. if the word "all" is typed all are ungrouped.
i can build an intereactive pop up box and whatever is typed i can get it to be copied to cell a1 but thats about it. Any help would be appreciated.
Thanks