Hi,
I have two Worksheets on same Workbook named Report & Config. A Range on Worksheet Report is set =Report!$A$195:$A$211 which I want to Show/Hide based on the value of a dropdown in Worksheet Config in Cell C20. Dropdown has two Values YES & NO. If Config!C20 = YES then Show Range, If Config!C20 = NO then hide this range & Worksheet Report automatically update when I change the value of C20 on WorksheetConfig
I will be thankful if someone help me with this.
I could not get this code working. Here is what I am trying to achieve
Please Login or Register to view this content.
That code looks nothing like the code from the linked thread.
Still the code is not working
Till now I have this Code
It works perfectly when I paste the code in New Workbook. I don't know why it is not working on workbook in which I want to get it working.Please Login or Register to view this content.
Last edited by aman179; 05-09-2012 at 12:29 AM. Reason: Updated code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks