unhide

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

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

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

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

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

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

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

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

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

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

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

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

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 :)

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

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

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

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

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

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

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