Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro written that cycles through every worksheet in my workbook
looking for a value of "Hide" in column D. If the criteria is meet, the row is then hidden. This macro is working nicely. I want to take it a step further, and in addition to hiding the row, set the form checkbox value to False. The corresponding checkboxes are in Column B, range is B40:B52. Not every row that meets the criteria to be hidden has a checkbox that needs to be changed to false, but if the line does have a checkbox in column B, then I want it turned to false. My code looks like this: Private Sub hiderowsif() Dim WS As Worksheet For Each WS In ActiveWorkbook.Worksheets WS.Select For Each c In Range("D3:D500") If c.Value = "Hide" Then c.Rows.Hidden = True End If Next c Next WS End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide Columns based on checkbox values | Excel Programming | |||
Checkbox to Hide/Unhide Columns Based on Value in Cell | Excel Programming | |||
PROBLEM: hide/unhide worksheets based on cell value change | Excel Programming | |||
Applying a change based on a CheckBox | Excel Programming | |||
A Print Button macro that is based on Checkbox macros | Excel Programming |