Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Sheets to Left Q
What code could I use to hide all sheets to the "left" of where the
active cell is? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Sheets to Left Q
try this:
Sub HideLefSheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Index < ActiveSheet.Index Then ws.Visible = xlSheetHidden Next ws End Sub On Mar 4, 9:28*am, Seanie wrote: What code could I use to hide all sheets to the "left" of where the active cell is? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Sheets to Left Q
On Mar 4, 10:10*am, AB wrote:
try this: Sub HideLefSheets() * * Dim ws As Worksheet * * For Each ws In ThisWorkbook.Worksheets * * * * If ws.Index < ActiveSheet.Index Then ws.Visible = xlSheetHidden * * Next ws End Sub On Mar 4, 9:28*am, Seanie wrote: What code could I use to hide all sheets to the "left" of where the active cell is?- Hide quoted text - - Show quoted text - Perfect, thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set all sheets to see A1 as left top cell | Excel Programming | |||
can i put sheets on the left and right of my screen | Excel Discussion (Misc queries) | |||
How to hide cell reference borders (top/left side) in Excel? | Excel Discussion (Misc queries) | |||
Quick hide bar on left side of spreadsheet/workbook | Excel Discussion (Misc queries) | |||
How to hide the column headings displayed by Excel at the left of. | Excel Discussion (Misc queries) |