unhide

Hi guys looking for a hint on what my problem is with the following code. I searched all worksheets and pulled back 3 sheets beginning with 1234567 which are in a string I need to now unhide sheets with the names from the string e.g 1234567 CAT to unhide sheet called 1234567 CAT any help...

The following code allows me to right click on a cell in column A and loop through 100 columns to hide them if there's no value in the corresponding cell: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) If Target.Column <> 1 Then Exit Sub Cancel = True Dim i As...

Hi I hope you can help me with below. In sheet2 cell B8 there's name of hidden sheet. Is there a vba I can use to unhide the sheet based on the value of this cell? when I use below it's working Worksheets("Template").Visible = True but I would like to refer to cell B8, which is variable...

Hey guys! I have a macro created that is near perfect for what I need. The only downfall is that it leaves the 50 rows the macro deals with unhidden. I need to add to my macro to hide all rows with rows 56 and 105 that have a value of N/A in column A. Example - cells A56:A66 all have a percent...

Hi all, Could I please ask if it may be possible to have a button to toggle between the following hide/unhide columns Hide J:M Unhide O:AB Then if pressed again Unhide J:M Hide O:AB Then if pressed again revert back to the start many thanks for any help

Excel friends, Can somebody help to find a code for Disabling and Enabling Delete Sheet and Unhide Sheet via VBA? The menu of Excel 2013+ should be greyed out. I have visited in too many sites, no luck!!! Thanks!

Hi, I have been tasked with cleaning up an old add in, however the Issue is that I have set the xlveryhidden sheets to xlvisible in the VBE but they are still not visible, I have also tried to unhide the sheet afterwards but all I can see is the standard sheet 1-3 tabs. Have I missed something?

Good day, I am new to macros but a quick learner!! I have a row of cells 11:16 that I have hidden ... I would like to add some VBA to a command button so that when it is clicked it unhides 2 rows per click ... Click once: 11:12 unhidden click a second time: 13:14 unhidden 3rd time 15:16...

I've got an excel file that has many lines hidden to make the file readable on one screen. but when I enter a number in column B I want the next row to unhide (ie the sheet is blank in B7 and when I put a number in B7 I want to unhide row 8 and if I put a number in B8 I want row 9 to unhide)...

I have several lines hidden but if there is a value >0 in B7 I need the Macro to unhide row 8. then if a value is in B8 I need it to unhide row 9 ect. can someone please help? Thank you for your time.

Hello! I have created a spreadsheet with 36 rows. However, when I recently opened the application, I now have over a million new rows. After row 17 it goes straight to row #1,000,000. I can’t view rows 18-36. I have tried to select all the rows and then click unhide. However nothing is working...

Hi, I recently watched a tutorial on youtube ( https://www.youtube.com/watch?v=gn8IZEM3GE4&feature ) on how to unhide a sheet depending on what you select in a dropdown, may question is, it is posible to have a multiple dropdown so i can unhide different sheets? thanks in advance -zhakista

I have a macro attached to an icon that will unlock the sheet, hide certain rows and column, bring up the application dialog to print and the unhide everything upon the print dialog box being closed and lock the sheet back up. Problem is, the print dialog doesn't seem to acutally print. Any...

I have a Table of numbers that is 10 columns wide x up to 50 rows long (Cells A1 thru J50 maximum). For presentation purposes, I need to hide the entire table and then unhide one row at a time, starting with row 1, then row 2, etc until all 50 rows are visible. I want to be able to control...

Good Day all, I have very limited knowledge on Marcos/ Event codes. I would really appreciate help with the below. I have a workbook with 2 Sheets. Sheet 1 (Form) Sheet 2 (Result). Sheet 1 contains multiple yes & no questions which kicks out a result on the Result sheet. I require a macro or...

I have inherited a spreadsheet and the first 4 rows are hidden. No matter what I do, I cannot figure out how to unhide them. I've done the f5 and type in the rows and then went to cells format and unhide rows but they do not show up. Help???

My worksheet is missing Row 12. I suspect that it is Hidden. However, when I click on the row's numbe and drag down from row 12 to row 13, Rt click and selext "Unhide" nothing happens. This method worked on another missing (Hidden) row but it's not working on this one. But I've noticed, in...

I have written code to unhide worksheets from sheet 2 , except the last 3 workbooks. I want to unhide Cols A:M When running the macro, it only unhides the active worksheet It would be appreciated if someone could kindly assist me Sub Unhide_Columns() Application.DisplayAlerts = False...

I have a Workbook that has around 400 hidden sheets. I need to do a consolidation of data from 104 of those hidden sheets. I have a list of the different tab names in a database inside the workbook in Tab HALB List (or Sheet 1) Column C Benchmix (C5:C308). I found a code that would unhide...

Running into a strange bug. I have a sheet that will cause Excel's GUI to completely lock up (as if ScreenUpdating was turned off) if I unhide any rows while calculations are enabled. What makes this strange is that this sheet is relatively rudimentary with only basic INDEX/MATCH formulas...