I have 4 workbooks. Column A of all 4 workbooks has a calculation which determines if the row should be hidden or not.
Each workbook has about 40 sheets.
I would like to record a personal macro that is able to run for all 4 workbooks so that I can hide the rows which need to be hidden. I would also like an unhide option, if possible.
Each workbook has about 40 sheets.
I would like to record a personal macro that is able to run for all 4 workbooks so that I can hide the rows which need to be hidden. I would also like an unhide option, if possible.