+ Reply to Thread
Results 1 to 1 of 1

Macro to hide columns and change formulas in multiple worksheets

  1. #1
    Registered User
    Join Date
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2010

    Macro to hide columns and change formulas in multiple worksheets

    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

    Please Login or Register  to view this content.
    Last edited by vlady; 10-02-2012 at 11:35 PM. Reason: Code tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1