| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show/Hide Columns
I want my user to be able to show or hide several columns in my worksheet.
If they are already hidden, they should unhide and vice versa. The following will unhide hidden columns, but will not hide unhidden columns. What am I doing wrong? Private Sub Detail_Click() ' Show/Hide Detail If Columns("B:Y").Hidden = False Then Columns("B:Y").Hidden = True Range("a1").Activate End If If Columns("B:Y").Hidden = True Then Columns("B:Y").Hidden = False Range("a1").Activate End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a quick way to show selected columns (not using hide) | Excel Discussion (Misc queries) | |||
| How to show columns/cells in sheet but hide them in print? | Excel Discussion (Misc queries) | |||
| Shortcut for hide/show detail in grouped columns/rows | Excel Discussion (Misc queries) | |||
| Macro to hide/show rows and columns | Excel Discussion (Misc queries) | |||
| how can hide and show columns using macro? | Excel Worksheet Functions | |||
Threaded Mode
