Hi All, I have a worksheet that previously had some "Yes / No" options in a drop-down list in various cells. This is a workflow checklist... I decided to replace the dropdown lists with checkboxes to facilite data entry. The workflow is dependent on the selection in a different worksheet, which hides or shows certain rows depending on the selection.
I added the checkboxes and option buttons with the default selection "move and size with cells", and assigned the output to certain cells. I then modified the code to hide a row, expecting that the rows under it that also have checkboxes, will move with the rows. It isn't happening. See code below. I made a small video, converted it to .gif format and tried uploading it, but apparently either the size of 728 kb or dimensions 1024 x 576 are too big for the upload.
I added the checkboxes and option buttons with the default selection "move and size with cells", and assigned the output to certain cells. I then modified the code to hide a row, expecting that the rows under it that also have checkboxes, will move with the rows. It isn't happening. See code below. I made a small video, converted it to .gif format and tried uploading it, but apparently either the size of 728 kb or dimensions 1024 x 576 are too big for the upload.
VBA Code:
If Model <> "Z8 or Z8 Neo" And Purpose = "Preventive Maintenance" Then
With Sheets("PM")
'Exchange Consumables
.Rows("12").Hidden = True
.Shapes("optPM_R9.1").Visible = False
.Shapes("optPM_R9.2").Visible = False
.Shapes("fr_R9").Visible = False
End With
End If