hide worksheet

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 =...

Hello Everyone In A1 i have a path d\temp\action.xlsm Action.xlsm Workbook has a worksheet by the name of secret Right now in current open active workbook.. name sample.xlsm. i have a button. I want if i click on that button action.xslm worksheet would be hide. In simple i want to hide...

Hi there, Hopefully the title is correctly describing what I need, but here I will elaborate. I will for example have the following worksheets: - Overview - Adam - John - Nick - Tess On the Overview sheet you will find the total of expenses per employee. The name in column A and the value in...

In cell F5 on worksheet "Instructions", I have a drop down menu. The user will either select "1" or "2". If the user selects "1", then I would like to hide the tab called "Org. 2 Calcs" and make sure the tab called "Org. 1 Calcs" is showing. If the user selects "2", then I would like "Org. 1...

I've had a PERSONAL workbook (binary worksheet) on my work computer for about 3 years, used to store macro functions that I can reference in all files and has worked great. I prefer to have the PERSONAL file hidden when Excel opens, however for some reason Excel will no longer open if I try to...

Hi - I am trying to assign a form control to run a macro which hides/unhides worksheets that contain specific characters in the worksheet name. I have the following code which allows me to hide/unhide the worksheets but I can't figure out how run it when I click the form control. Thoughts? Sub...

Hi Folks: I would like to fire a macro (to unhide specific worksheets) when a selction is made from a data validated drop dow cell. For example, let's assume I have a named range of comprising the names of several fruits" Apples, Bananas, Cantelope etc. One the user selects Apples from the...

Today I opened a spreadsheet that I haven't referenced in 6+ months. There are 2 worksheets that I know are there, but I can't make them visible. How do I know they're there? (1) there are formulas in the worksheet I can see that references the hidden ones and (2) when I try to create a new...