hide sheet

Hello fairly new with vba but having some issues... I have a workbook with 3 sheets. Lets say sheet A sheet B and sheet C. Sheet B is a a form with data entered in certain say cell C5 , F11 and G15. In a nut shell I want to make an archive by copying a sheet, rename it, hide it, and clear the...

Hi all, I'm attempting to Hide Sheet titled "LOW" if B2 is "FALSE", or Unhide if B2 is "TRUE", however when I press 'Run Sub', the Macros Dialog Box pops up. I've attempted to find the answer elsewhere, but to no avail. CODE AS FOLLOWS: Private Sub Worksheet_Change(ByVal Target As Range) If...

Hello everyone, I have a file that I use for quoting. For each product I have the following sheets/tabs....Cost, Financial Model, NPV, Sensitivity, and Amort. When I have multiple products I am quoting at the same time I end up having one file with a very long list of sheets. I want to be able...

Hi all (office 97) I have used this site for years, but this is my first post, as I can't get any of the older posts to work. I have a workbook over about 15 sheets including charts. When you open it up you can only see the "INTERFACE" sheet and use buttons to select all other sheets /...

Hi there, I am new to VBA and was hoping someone might be able to help me. I have a drop-down list in cell C4 on Sheet1 and when a user selects a specific item "-" I would like this to hide Sheet3. If the user selects any other item I would like Sheet3 to be visible. Ideally this would be...

Hello, I am in the middle of a project where I have a "main" page that is a hub with hyperlinks to other sheets. I would like to keep the sheets that the hub links to hidden so that it does not clog up at the bottom. The problem though, is that if you hide a sheet, you cannot access it. I was...

Let's say I have Sheet1-Sheet6. I also have combobox1 (with item 1, 2, & 3 as the list items) & combobox 2 (with items 1 & 2 as the list items). If combobox1 = 1 & combobox2 = 1 then hide Sheets 2,3,4,5,6 if combobox1 = 1 & combobox2 = 2 then hide Sheets 1,2,4,5,6 If combobox1 = 1 & combobox2...

hi frnds [code] Sub UnhideAllSheets() 'Unhide all sheets in workbook. Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If LCase(Trim(ws.Name)) <> "sheet3" Then 'how can i choose two sheet instead for one ("sheet3") ws.Visible = xlSheetHidden End If Next...