| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
display only columns A to I
Thanks to Don and Mike. Your suggestions work great.
Mike Fogleman wrote: Put in the Worksheet_Activate event. Private Sub Worksheet_Activate() Sheets("sheet1").Columns("J:IV").Hidden = True End Sub If they unhide the columns manually, you can re-hide them with this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Sheets("sheet1").Columns("J").Hidden = False Then Sheets("sheet1").Columns("J:IV").Hidden = True Else: Exit Sub End If End Sub Mike F "John Smith" wrote in message ... I want users to be able to see only columns A to I. The following code works in the worksheet_selectionchange() but I don't want it to execute everytime users make a change on the sheet. If I put the code in a module, no column is visible. The sheet is completely blank. Any help? Sheets("sheet1").Columns.Hidden = True Sheets("sheet1").Columns("A:I").Hidden = false Sheets("sheet1").Columns("A:I").Show |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display columns alphabetically | New Users to Excel | |||
| How can I group and display columns automatically? | Excel Worksheet Functions | |||
| Compare columns and display the value | Excel Discussion (Misc queries) | |||
| Scrolling columns display | Excel Programming | |||
| compare two columns and display a third | Excel Discussion (Misc queries) | |||
Threaded Mode
