unhide sheet

  1. M

    Unload/Unhide Sheet Based on Name

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

    vba script to unhide next tab only if a cell value is correct

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

    VBA: Hide and Unhide Problem

    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)...
  4. B

    Button to Push data to a sheet

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

    Unhiding worksheets

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

    VBA to Unhide Sheets to the Right

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

    Unhide Sheet and copy data from specific cells to now unhidden sheet

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top