| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autoamtically hiding a column after moving to a next cell outside
I have hidden a column, which only unhides, when a certain category is chosen
in the previous column. However after one has entered the required info and moves to the cell in the next column I would like the column automatically to be hidden again. Any solution to that would be much appreciated |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autoamtically hiding a column after moving to a next cell outside
post what you have so far
-- Don Guillett SalesAid Software "Frederic" wrote in message ... I have hidden a column, which only unhides, when a certain category is chosen in the previous column. However after one has entered the required info and moves to the cell in the next column I would like the column automatically to be hidden again. Any solution to that would be much appreciated |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autoamtically hiding a column after moving to a next cell outs
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 And Target.Value = "Locators" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Detectors" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Survey/Navigation Equip." Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Machinery" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Medical Equip. Cap. Assets" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Weapons" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Desktops" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Laptops" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Printers" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Scanners" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Digital Cameras" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Radios" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Sat Phones" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Mobile Phones" Then Columns("G").Hidden = False ElseIf Target.Column = 5 And Target.Value = "Vehicles" Then Columns("G").Hidden = False End If End Sub "Don Guillett" wrote: post what you have so far -- Don Guillett SalesAid Software "Frederic" wrote in message ... I have hidden a column, which only unhides, when a certain category is chosen in the previous column. However after one has entered the required info and moves to the cell in the next column I would like the column automatically to be hidden again. Any solution to that would be much appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding a column of hyperlinks behind a column of numbers | New Users to Excel | |||
| Value in the last cell of a moving column | Excel Discussion (Misc queries) | |||
| Moving scattered cell data to new column? | Excel Worksheet Functions | |||
| Hiding the error caused by the formula in a cell / column | Excel Discussion (Misc queries) | |||
| moving column/cell data to rows/cells fails | Excel Worksheet Functions | |||
Linear Mode
