Macro to hide rows - Amazon gift card to whoever can help!

Maybe:

Please Login or Register  to view this content.

code should go in the Show-Hide sheet code

John,
How exactly do I enter this code?
Do I create a new macro or open visual basic?
If so, do I just paste that and hit save, or do I have to do anything else?
My apologies, I just have never used VB or Macros before.

I notice you have 2013. So I'll do my best to explain. If you do not have a Developer's Tab on your Menus, you will have to Open it. You need to go too Excel Options and select Customize Ribbon from the choices. From there you will see on the Right side of your screen a dropdown list (Customize the Ribbon). Check the Developer. You will be able to access your Visual Basic Editor from this Menu which will now be an option. Once inside the Editor, look on the Left Hand side it will lists VBA Projects. Choose the one with the Workbook name (ExcelHelp - was your sample). Under this Project will be sheet names. Click on the one for "Show-Hide". Again you'll see two Dropdown lists. One the left hand side choose "Worksheet" - On the right hand side choose "Change". That is where you would paste the code. You can copy the lines after the Sub and prior to the End sub, And paste there. I hope I've been clear.

Does ALT+F11 still open VBA in Excel 2013? That's how I access it on machines that I don't have the developer tab added yet.

Hope that helps

Originally Posted by DarkF1ame

Does ALT+F11 still open VBA in Excel 2013? That's how I access it on machines that I don't have the developer tab added yet.

Hope that helps

I thought it was probably something that simple, but I admit, I don't have a clue. I hope the op does.

When I press Alt+F11, where do I paste your code?
I pasted it after the code that was already in there, clicked save, and then used the drop down buttons and nothing happened.
Screenshot below of what pops up when I press Alt+F11
Screenshot.jpg

Possibly you could enter the code into the ExcelHelp spreadsheet I attached in the original post and save it and attach that?

Here. Try this ExcelHelp.xlsm

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

Ahh, John, in testing, I actually did notice something wasn't working.
I can't seem to hide multiple rows at once.
Example, if I change both "Category 7" and "Category 8" to "No" on the "Show-Hide" worksheet, Category 7 reappears on the other worksheet, while Category 8 is hidden. Thus it seems when I toggle a second category, it untoggles the prior category.
Ideally, the macro would need to match the identifiers in column 1 on the "Show-Hide" worksheet with the identifiers on the other worksheets to prevent this.

Any thoughts?

Try ExcelHelp.xlsm