Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Bobby,
for toggling show/hide try this macro: Public Sub ShowHideUnNamedToggle() Application.ScreenUpdating = False Dim I As Long Dim Hidden As Boolean For I = 1 To 24 If Rows(I).EntireRow.Hidden Then Hidden = True Rows(I).EntireRow.Hidden = False End If Next I If Hidden Then Exit Sub For I = 1 To 21 Step 4 If Left(Cells(I, 1).Value, 4) = "Unit" Then Range(Cells(I, 1), Cells(I + 3, 1)).EntireRow.Hidden = True End If Next I End Sub Assign macro to a button from the Forms toolbar, add the caption "show/hide" GoodLuck Ken Johnson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Generic protect/unprotect code through buttons and code? | Excel Programming | |||
How to make a button VBA code reference other VBA code subroutines??? | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming |