hide worksheets

Hi, would it be possible to simplify & speed up this code? Thank you. Sub HIDE_ALL() With ThisWorkbook .Unprotect password:="1111" If Worksheets("WB_1").Visible = True Then Worksheets("WB_1").Visible = False End If If Worksheets("WB_2").Visible = True Then Worksheets("WB_2").Visible =...

I have a worksheet that acts as a Table of Contents, called "TOC". There are dozens of worksheets behind it, which all have an identical format set of headers rows. One of those cells, cell B6, which contains a drop down lists of category, so that I can categorises each worksheet, like...

Hi - I have a code (shown below) that is creating multiple copies of a template worksheet and number sequentially. The problem is that I would like to have the template worksheets hidden, but when I do this I get a Run Time Error 1004: Method Select of Object_Worksheet failed. If not hidden, it...

Hi, I have about fifty worksheets most of which are named with two letter country codes. I am using a data validation drop down list to select the relevant country code (US, CA, EU etc…) worksheet in order to hide all the other country worksheets. However, I don’t want to hide all the...

Hello, I am continually running into an issue when trying to protect my workbook with macro's I have a workbook with 12 sheets. Upon workbook_open, I hide them all, except the first which is protected completely, no one can even click on a cell. At the end of the code, I protect the workbook...

Hi - I am trying to show / hide worksheets that start with a specific character based on a List selection. The following code will show or hide the worksheets however I can't figure out how to run the code based on a cell value. For example, if B15 says "Show Detail" then show worksheets...