Hide Rows on Sheet2 if Sheet3 is visible

[penny]

Hello -

I have a spreadsheet with 10 hidden worksheets. Sheet1 and Sheet2 are always visible. A user can click one of 10 buttons on Sheet1 to make one of 10 sheets visible. I need to hide rows 5 through 10 on Sheet2 if Sheet3, Sheet4 or Sheet5 is made visible. Any suggestions on how to do this?

Thank you!

[BadlySpelledBuoy]

What's your code for making the sheets visible when the buttons are clicked?
Should be able to fit something in there.

BSB

[Winon]

Hello penny,

We could solve your issue depending on which Command Buttons you have deployed. Without seeing a sample of how your Workbook is setup, it would be a guessing game.

Please attach a sample workbook (not a picture or pasted copy). 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.

Regards.

[penny]

Ahaha! This was all I needed to make me realize I was overthinking this. Here's the code I used:

Please Login or Register  to view this content.

[Winon]

Hello penny,

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.