One of our user had the need for a button to "Show" or "Hide" the monthly details in order to avoid report clutter: This how we did it: On the parameters sheet we added an entry for each column we might want to hide: On the top row of our data sheet we added the following formules: =XL3ColumnVisible(Parameters!$B1) =XL3ColumnVisible(Parameters!$B2) =XL3ColumnVisible(Parameters!$B3) =XL3ColumnVisible(Parameters!$B4) etc Once you have tested everything you can hide this row! In Cel B3 we added the following formula: = IF(Parameters!B1=FALSE, XL3Link(XL3Address($A$1),"Show Details",3 ,XL3Address(Parameters!$B$1),TRUE ,XL3Address(Parameters!$B$2),TRUE ,XL3Address(Parameters!$B$3),TRUE ,XL3Address(Parameters!$B$4),TRUE ,XL3Address(Parameters!$B$5),TRUE ,XL3Address(Parameters!$B$6),TRUE ,XL3Address(Parameters!$B$7),TRUE ,XL3Address(Parameters!$B$8),TRUE ,XL3Address(Parameters!$B$9),TRUE ,XL3Address(Parameters!$B$10),TRUE ,XL3Addres
Comments
Post a Comment