Hello,
I wanted to hide specific rows in multiple sheets.
I've sheet "Info" which have dropdown list (View,Hidden).
I also have sheets "Jan" to "Dec"
When i choose dropdown list "Hidden" in sheet "Info". It should hide all the specific rows (Example rows 1:10) in all sheets "Jan" to "Dec".
I have create the code but it doesnt work.
Really appreciate if someone can help me.
Thank you.
I wanted to hide specific rows in multiple sheets.
I've sheet "Info" which have dropdown list (View,Hidden).
I also have sheets "Jan" to "Dec"
When i choose dropdown list "Hidden" in sheet "Info". It should hide all the specific rows (Example rows 1:10) in all sheets "Jan" to "Dec".
I have create the code but it doesnt work.
Really appreciate if someone can help me.
Thank you.
