unhide sheet

Hello Gurus, I am trying to create a macro where in if the cell value in the MAIN sheet matches one with the hidden sheet name, macro will unhide it. By the way, those Data x Sheetswhere hidden because there's too many. Example: In the MAIN sheet, if cell Value in A1 is "DATA 1" then it...

Hi, I am trying to unhide a very hidden worksheet based on a name picked from the drop down list. I am getting a Run-time error 91 Object variable or with block variable not set on the "If ws = Worksheets("Administrator").Range("B9").Value Then" line. Any ideas on how to fix this? Code: Dim...

I have to create a database form. I want to unhide next sheet with the same fields only if the value of a particular cell is correct. For instance - the answer to question "Do you want to add more?" is "Yes" then the next sheet will appear, otherwise will remain hidden. Same way if the same...

When I run the code below i always get a error. I just simply want to unhide sheet9 for 5 seconds then hide it and return back to sheet Burn. Sheets("Sheet9").Select ActiveWindow.SelectedSheets.Visible = True Application.Wait Now + TimeSerial(0, 0, 5)...

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

Hi everyone, This is the first time I've tried any VBA, but this is what I've been trying I've been asked to create a workbook with a list on it (I've used validation to create a drop down list); which contains the names of the other worksheets in the workbook. THese other sheets are...

After hiding all sheets (already done), I'd like to be able to unhide just certain sheets in the workbook, all of which are to the right of a selected sheet. I'd like this to be dynamic, so I'd like to be able to change the active sheet in the code and have all sheets to the right unhidden...

I am looking for help regarding a check box function. I have a macro that fires when a checkbox is clicked on(to "check" it). The macro unhides a hidden sheet within the workbook. I need the checkbox to not only unhide the hidden sheet, but also to copy certain cells within the Main Input...