hide sheets

I have 20 worksheets. I need to hide those worksheets by macro according to a value in its own specific worksheet. For example,0=hide worksheet, 1=do not hide worksheet: Worksheet 1, fieldA1=0 --> hide worksheet 1 Worksheet 2, fieldA1=1 --> do not hide Worksheet 1 Worksheet 3...

Hi, I'm not sure if this is possible, but I'm hoping there is some VBA that could help me. I have a spread sheet that will hold summary pages for 4 different teams. I don't want each team to be able to see each others summaries, so I want to hide all of the sheets, and maybe have a front end...

Hello, How can I allow to hide sheets in my locked workbook? The code below doesn't work. I receive Error 1004: Application-defined or object-defined error. If I unlock my workbook than the code passes. Private Sub Workbook_BeforeClose(Cancel As Boolean) For Each ws In ThisWorkbook.Worksheets...

I want a couple of worksheets to automatically hide when they are not active. I currently have a "go to" button which calls the sheet when I need it but I want these worksheets to be hidden when the user moves to another sheet. Can you please kindly help Thank you

Hi, i need to hide worksheets based on the content of a cell. I have a summary sheet (called "voorblad") the trigger for one sheet should be the contect of a cell in collumn Q (i.e. Q7) and the name of the sheet is one the same row in collumn C (i.e. C7). this repeats every 3 rows. I want to...

I have a a few lists on the tab "Master" in cells D3:D10, D12:D16, and D18:D24. These lists have the names of workbook tabs that I want hidden. Is there a quick way to hide all of these tabs so I don't have to do it manually? This is the code I have to hide the first tab but would like a...

I found this code searching forums and I have a specific use for it and I am trying to get it to function. I have only made minor changes to it so that it recognized the user row to determine which sheets to unlock. The idea is to prompt for username and password and then unhide the sheets that...

Hi, The following macro works, however I am trying to clean up the code Sub ShowSet1() Dim xWs As Worksheet Dim xName As String xName = "Sheet5" For Each xWs In Application.ActiveWorkbook.Worksheets If xWs.Name <> xName Then xWs.Visible = xlSheetHidden End If Sheets("Sheet1").Visible = True...

I am trying to create a button on the ribbon that will allow the user to hide only sheets not selected. For example, if I have workbook with [Sheet1, Sheet2, Sheet3, Sheet4] and the user has selected [Sheet1 & Sheet3] then [Sheet2 & Sheet4] would hide. I have the VBA to hide all (except the...

Hi All Can anyone help with my condurum which I can't get to work: For Each ws In Worksheets If ws.Name = "Sheet1" And ws.Name = "Sheet20" Then ws.Visible = xlSheetVisible Else ws.Visible = xlSheetHidden Next For some reason it seems to be also hiding the sheets I've defined to remain visible...

I saw this on the message board, which works to hide all sheets but Sheet1. How do I modify it to hide all sheets except Sheet 1 and Sheet2? Dim sht As Object For Each sht In Sheets If sht.Name <> "Sheet1" Then sht.Visible = xlSheetHidden End If Next sht

Hi, This is driving me crazy! The idea... The user selects a value in a drop-down list, which triggers some sheets to be hidden-unhidden, and fills-up a cell with a message of the outcome. I want to use a single UDF to which I pass variables as needed (i.e. re-use the UDF for each sheet to...

Hi, I have a total of 15 sheets on my excel documents. I've hidden 10 (5 sheets will be shown) of those sheets so i can hyperlink to them from the sheet called "The plan". The name of the hidden sheets are called: "Week 1" "Week 2" "Week 3" "Week 4" "Week 5" "Week 6" "Week 7" "Week 8" "Week 9"...

Hello, I wrote a macro to select multiple sheets by name and hide them, but I keep getting the following error message: "Object variable or with block variable not set". Below is the macro: Sub HideSheets1A() Dim ws As Worksheet Application.DisplayAlerts = False If ws.Name = "Variance...

I thought this code seemed pretty simple - All I need to do is unhide a sheet. From the Macro recorder I got: Sheets("Archives").Select ActiveWindow.SelectedSheets.Visible = True When I run my Macro I get Run-Time Error '1004' select method of worksheet class failed

Hello All.... I have been working for sometimes on a workbook to calculate marks for my class. My workbook is comprised of 4 sheets. 1. Tools sheet, where I have a list of the various tools that a teacher uses in order to come up with a "Final Mark" for the term, 2. A sheet which summarises and...

Hello, I need a macro that will hide sheet tabs with certain names as well as delete other sheets. However when it comes to processing the code where it has to check for sheet names and hide or leave alone, I am running into an error. Below is the code I'm using: Sub DeleteSheets2()...

Hi all, I'm making my first moves in the excel macro world, and having the following difficulty: I have an excel sheet in which I build in some checks and macros, so therefore I need to ensure that users execute macros when opening the file. I looked around on the internet and found that...

Hello everyone, I'd like to alter some VB code to hide all the sheets not labeled "Goals". Basically, what I am trying to do is have a user run a macro, have Excel open the "Goals" tab, and hide all the other sheets in the workbook. Do I need to list all my other sheets, or can VB just hide...

Hi, I need to resolve a pressing issue that I have at work. Here is my dilemma. Background Info: Currently, I have 15 users who submit data to me on Excel 2003 spreadsheets that I in turn manipulate to report elsewhere (to upper mgt, the government, etc…). In the short term, I need...