Hide Rows if Cells in Range = False, Separate Sheets

[lexskoza]

I have four sheets, checkbox results (True, False) from Sheet1 are seen in column A on Sheet3. Now if the result is False, I want the corresponding row in Sheet3 to hide.

- On a side note, the checkbox, when unchecked (False) will hide it's corresponding Row in Sheet1, is there a way of linking the result from the same action? If so, which option would require the least amount of code?

I've tried a number of things, but can't get it quite right!

[walruseggman]

Put this in your sheet 3 object:

Please Login or Register  to view this content.

[lexskoza]

I keep getting an error sound, like it won't try to run the code?
I changed FALSE to False, as I've gotten errors due to that before. But still no luck.

And just so I can make sure I'm not making some other error, I am to paste/write that into the Visual Basic Editor, under Sheet3?

[Winon]

Hello lexskoza,

Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you.