I have a worksheet with several toggle buttons. When one of the toggle buttons is clicked it runs some code which checks the status of each toggle button (TRUE or FALSE), but I need to find the address of the linked cell to drive which columns to hide or display (I want to hide the two columns after the linked cell column), but I can't work out how to find the linked cell address.
A sample worksheet is attached (the real one is a lot more complex!). Any help would be much appreciated.
Many thanks
Shirley
Bookmarks