Hi I'm learning macros on the fly and have to admit probably go about it the wrong way. I have created a monster and the element of hiding columns does not work.
This is a cba model and the idea is to choose the length of time for a business case between 2, 3, 5 & 10 yrs. with one of these years selected I want the workbook to change the formula on some financial indicators in the 'Calculation' worksheet (this works) and hide relevant columns in the input and reporting worksheets. I only want to hide in case the there is a change in mind to the length of the proposal.
Unfortunately the workbook is too large to attach I did a cut down version but it is still too large. Some of this marco unhides and then hides worksheets as not all worksheets need to be visible in the initial use of the workbook this element work fine. The area not working is the highlighted in <Blue bold> and is repeated at the 3 year and 5 year code
Bookmarks