paradise
10-16-2016, 06:51 PM
The workbook is extracted from http://www.vbaexpress.com/forum/showthread.php?57033-Multiple-Dependent-Checkbox-to-hide-unhide-sheet given by VBAX Guru mikerickson (http://www.vbaexpress.com/forum/member.php?10706-mikerickson) .
I have group the rows D3 : D4 which represents to B2 heading.Similarly,B6 :B9 represents to B5 heading and so on in Master Sheet.
Now when you move from B2 to A2 then A2 gets checked on and again when you go on A2 then it will get unchecked.Similarly, when moved from B5 to A5 the same will be checked on and off.
Here, what I want is that it should get automatically expand below rows which has been grouped when once get checked on.Suppose, when B2 heading is get checked on A2 the rows below should get expand automatically.
Similarly,when B5 heading is get checked on A5 the rows below should get expand automatically and so on.
Others things remaining the same.
I have group the rows D3 : D4 which represents to B2 heading.Similarly,B6 :B9 represents to B5 heading and so on in Master Sheet.
Now when you move from B2 to A2 then A2 gets checked on and again when you go on A2 then it will get unchecked.Similarly, when moved from B5 to A5 the same will be checked on and off.
Here, what I want is that it should get automatically expand below rows which has been grouped when once get checked on.Suppose, when B2 heading is get checked on A2 the rows below should get expand automatically.
Similarly,when B5 heading is get checked on A5 the rows below should get expand automatically and so on.
Others things remaining the same.