| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Rows Across Mulitple Sheets
Good Monday All: I have a workbook with 57 sheets which
are all identical. I need to hide the same columns on sheets 15 to 30 when a button on the idex sheet is pressed. All help is appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Rows Across Mulitple Sheets
for i = 15 to 30
worksheets(i).Range("C:M")EntireColumn.Hidden = True Next -- Regards, Tom Ogilvy "Jason Penny" wrote in message ... Good Monday All: I have a workbook with 57 sheets which are all identical. I need to hide the same columns on sheets 15 to 30 when a button on the idex sheet is pressed. All help is appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Rows Across Mulitple Sheets
Jason,
There's probably an easier way, but this works: [watch word wrap] Sheets(Array(15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)).Select Columns("E:G").EntireColumn.Hidden = True or loop Dim x As Integer For x = 15 To 30 Sheets(x).Columns("E:G").EntireColumn.Hidden = True Next both are fast. -- sb "Jason Penny" wrote in message ... Good Monday All: I have a workbook with 57 sheets which are all identical. I need to hide the same columns on sheets 15 to 30 when a button on the idex sheet is pressed. All help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I append multiple sheets from mulitple xls. files. into 1 | Excel Discussion (Misc queries) | |||
| how to duplex mulitple sheets simultaneously? | Excel Worksheet Functions | |||
| KBV - How do i progam a recorded to repeat on mulitple sheets? | Excel Discussion (Misc queries) | |||
| Hide rows and update fileds in different sheets | Excel Discussion (Misc queries) | |||
| How do I convert an Excel workbook that has mulitple sheets into . | Excel Worksheet Functions | |||
Linear Mode
