LoneStarPiper
New Member
- Joined
- Mar 29, 2019
- Messages
- 15
Hello all. I have a macro that hides and unhides several rows on a sheet, and works perfectly when on I use a button ON THAT SHEET. I have another sheet that has a checkbox that when selected, should run the exact same macro and for some reason it only runs half of it. I'm losing my mind, can anyone help???
Above is the code on a button in sheet called "Agreement".
On another sheet, I have check boxes to run a series of macros. When the check box is selected, this is the macro it should run:
What seems to happen is that it "hides" the first line, but doesn't "unhide" the second. Any suggestions?
LoneStarPiper
Code:
Sub InstallerCopyNOPrint()Sheets("Agreement").Rows("43:100").Hidden = Not Rows("43:100").Hidden (THIS ONE GOES FROM NOT HIDDEN TO HIDDEN)
Sheets("Agreement").Rows("101:113").Hidden = Not Rows("101:113").Hidden (THIS ONE GOES FROM HIDDEN TO NOT HIDDEN
End Sub
Above is the code on a button in sheet called "Agreement".
On another sheet, I have check boxes to run a series of macros. When the check box is selected, this is the macro it should run:
Code:
'Installer Copy Checkbox values are 0 (false), 1 (true), 2 (changed or grey) If Worksheets("Admin").CheckBoxes("chk3installcopies").Value = 1 Then
Call InstallerCopyNOPrint
Call Agreement_Print
End If
What seems to happen is that it "hides" the first line, but doesn't "unhide" the second. Any suggestions?
LoneStarPiper