| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display only columns A to I
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
