unhide

  1. M

    How to hide sheet and can be unhide with password

    I have several tabs in Excel I need to hide. I know we can using Veryhidden but that can still be unhide without password. I know we can select VBAProject password but that works only if there is VBA code and my file cannot have VBA code for compliance. So any way to achieve my need ? Thanks I...
  2. H

    Macro of Very Hidden Sheets

    Is there a Macro that will unhide all the Very Hidden Sheets in the Workbook?
  3. MFish

    Resize columns through VBA

    Hi, I am making a userform with checkboxes that will be a "Filter what you want to see" action. When you checkmark a checkbox it will then hide the designated column. When you uncheck it, it reverts back to unhide. My problem I have is it works great until you unhide the column and the...
  4. C

    VBA enter password to unhide worksheet

    ThisWorkbook.Worksheets("jun payroll").Visible = xlSheetVisible I am using the code above which unhides a worksheet when a button is clicked. How do I set it so that a password is required to unhide it? I am new to VBA so if you could write the code in your response that would be a huge...
  5. C

    CheckBox Control only works one way

    So I have a checkbox on the page that I want to hide and unhide a row, playing the script it works perfect but when I click the checkbox it only works once but wont uncheck and unhide. Im sure its simple but I'm missing it somewhere. I have the checkbox declared as a variable already when I...
  6. V

    Hiding columns/rows?!

    Hi, I was wondering about copying what's hidden on one sheet to another sheet. If I hide columns/rows as hidden data, can I copy the info as hidden to another sheet and still unhide the info inside the new sheet? Thanks, Studt#37
  7. M

    Worksheet un hide itself

    In my workbook, I hide some worksheets and save the file, when I reopen the workbook all hide sheet unhide itself. I am using Excel 2019. Thanks in advance
  8. S

    Unhide

    I received an excel file contained 12000 rows after that gray area is appearing I tried to unhide that to see row No.12001 but not able to, please help to unhide the remaining rows
  9. B

    Help with unhide macro

    Hi Everyone, I run the following code to UNHIDE a sheet(LOTTERY RECEIVED) from a button on a different sheet(LOTTERY). It works fine except I would like the sheet(LOTTERY RECEIVED) to be the active sheet in the workbook. Not quite sure how to get there? Thank You!! Sub...
  10. H

    Unhide Columns VBA

    Hi, I use the following code to unhide rows incrementally. How can I change it to unhide Columns in the same manner? Example, my hidden columns would be columns C through H Sub Unhide_Rows() Dim i as Long With ActiveSheet For i = 21 to 35 If .Rows(i).EntireRow.Hidden Then...
  11. C

    Unhide columns - does not work?

    Hi, Created a Pivot Table and a Pivot Chart. I want to hide all the data details in that sheet and only display the chart and slicer, which works perfectly fine. The only problem is I can not unhide the columns again even though they are all marked and I click "unhide". I've been going with...
  12. D

    Macro to unhide a sheet based on a cell value.

    I'd like to make a macro to unhide a sheet by double clcking on a cell. The cell value would have the same name as the sheet. let's say I have this line: (A1) "Sheet1" : (A2) "NAME" : (A3) "NAME So by double clicking any were in the row 1 would unhide sheet "SHEET1" Also, is there a way to...
  13. R

    protect unhide worksheet VBA

    Hi everyone, I want to protect sheet, cannot unhide sheet or set password for unhide sheet (only specific sheet) anyone who can know code in VBA Thank you in advance for your respond :)
  14. P

    Column "E" not unhiding

    Hi all This is very strange. I have hidden columns D, E, and F. When I go to unhide them, Column "E" does not unhide. It is a very large program with many macros. I even tried to unhide column 'E' with a macro but that still did not work. Any thoughts on what is causing the problem? I am...
  15. B

    Hide/unhide columns of multiple sheets using tickbox - some locked cells

    Hello I hope you all can help. Sheet1 contains an activeX control (checkbox) which once ticked, columns H:M in all sheets sheet2, sheet3, sheet4, sheet5 will hide themselves (and when unticked, reveal themselves) The VBA used (from another thread) is: Sub ShowHideColumns() 'Assuming...
  16. A

    Vb Code Unhide rows

    Dear Sir, I am using following code to add rows from A5:A498 It add rows in a way like, It unhide Row: A9:10, then A13:14 A11:A12 keep hidden, same way it goes all the way to A498 Sub addrow() Dim Ar As Areas Set Ar = Range("A5:A498").SpecialCells(xlVisible).Areas...
  17. A

    Hide\UnHide columns - automatically base on cell value

    Hi guys, i've been looking, in forum, for some related request and i've not found anything that fulfill my intentions. If i am mistaken, please accept my apologies :( what i'm trying to do is something like this. Have a 30, consecutive, columns with date and i'm trying to figure it out a...
  18. B

    Hide/unhide columns of multiple sheets using tickbox

    Hello I have a tickbox in Sheet1 and I would like a VBA that when this is ticked, columns H:M in ALL of Sheet2, Sheet3, Sheet4 and Sheet5 will hide. Then if this box is unchecked, they will reveal themselves. I've seen examples where a VBA can apply to a single sheet, but is there a way it can...
  19. R

    Protected Sheet - Hide/Unhide Rows based on user input and other cell values

    Hi Everyone, I have been able to find parts of the VBA for what I wouldlike to do, but not a solution that will work for my situation. I have a password protected spreadsheet with a projectlist. Projects are listed in Rows 10 – 200. Column D contains project status (Open, Closed...
  20. W

    Unhide a sheet

    I have a workbook with multiple sheets. Several are hidden but the names are available in the VB. I am looking to permanently unhide my sheet with the name "Dist" I have been over the forum but just looking for the basics here to unhide this one sheet and maybe the other sheets in my workbook...

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
Back
Top