Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding named ranges depending on a cell value
Hi I ahve a combo box, which changes the value in cell depending on the choice u pick. the bumber in the cell is either the letter A, or the letter B My problem is that the macro doesn't hide or unhides... and I can' seem to understand what the problem is... Can anyone see the error in the macro below? Macro: Sub Hide_unhide_date_period() ' This procedure hides and displays the dates / period input cells depending on the CC selection on the front sheet. ' Written by Christian Simonsen 17/03/06 Dim myCell As Range With Application ScreenUpdating = False DisplayAlerts = False End With Set myCell = ActiveCell If Worksheets("TM1").Range("G15") = "A" Then Range("Project_Periods").Select Selection.EntireRow.Hidden = False Range("Project_dates").Select Selection.EntireRow.Hidden = True ElseIf Worksheets("TM1").Range("G15") = "B" Then Range("Project_Periods").Select Selection.EntireRow.Hidden = True Range("Project_dates").Select Selection.EntireRow.Hidden = False End If myCell.Select With Application ScreenUpdating = True DisplayAlerts = True End With End Sub -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=524273 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding named ranges depending on a cell value
Hi Ctech,
Had a similar case ... following is working for me : ActiveSheet.Range("A14:A18").EntireRow.Hidden = False HTH Cheers Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding named ranges depending on a cell value
Hi Ctech, Had a similar case ... following is working for me : ActiveSheet.Range("A14:A18").EntireRow.Hidden = False HTH Cheers Carim That is exactly what I ahve done, isn't it -- Ctec ----------------------------------------------------------------------- Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774 View this thread: http://www.excelforum.com/showthread.php?threadid=52427 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding named ranges depending on a cell value
Very embarrasing.... I refered to the wrong cell.... Sorry guys.... it all works fine no -- Ctec ----------------------------------------------------------------------- Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774 View this thread: http://www.excelforum.com/showthread.php?threadid=52427 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two ranges and get true or false in one cell depending onresult | Excel Worksheet Functions | |||
Named Ranges - accessing a cell | Excel Discussion (Misc queries) | |||
Named Cell Ranges | Excel Discussion (Misc queries) | |||
Named Cell Ranges | Excel Discussion (Misc queries) | |||
Hiding Named Ranges | Excel Programming |