unhide

Hello All: Looking for some VBA to do the following: I am routinely hiding and unhiding rows 5 through 15 on a number of worksheets in one workbook. Would like some code that when run would hide the rows if unhidden -THEN- unhide the rows if hidden. Will assign to a button thereafter. Thank...

Hello! I am trying to write a macro that will loop through all files in a folder, unhide all tabs, and then save and close - i expected this to be simple but i am struggling to find anything that i can get to run! I'm not sure if the files being downloaded from sharepoint is making a difference...

Hi All Im after some code that will always make sure that there are 10 rows available from the last row with data on and have the formulas and formatting still in. I have hidden rows and columns to make it look much neater, but if they need to enter more 10 tasks in, will need to unhide, copy...

Greetings everyone... Longtime viewer but 1st time poster. Hopefully this will make sense... I have a userform that tracks who gets a project revision when the person the project belongs to is gone (this part works great). In this userform there is another userform that allows me to alter the...

I hid a lot of sheets, now I seem tho have to unhide them one by one. Is there a btter way?

Microsoft is steadily improving Office 365, but a thorn in our collective side for decades has been the constraint that we can only unhide one worksheet at a time from within the Excel interface. Yes, we can use VBA to loop through and unhide all sheets, but this is a basic usability feature...

I'd like to unhide columns based on clicking the a button that I have created. When the user clicks the button, columns F-I would unhide. When the button is clicked again it moves to unhide the next group of columns J-M and so on. I'd like to use the same button to keep this quoting worksheet...

Hi! I am looking for a code that will create a popup menu that appears when a user opens the workbook. The menu would have 4 choices and each choice would unhide a different set of tabs. Below are the menu names and tab combinations. I'm not even sure where to start. TIA!!! Menu Option...

Hey everyone, I am using the following code to hide rows in a workbook where column A has the value "Hide". However going through 500 lines seems to take a long time. I am wondering if there is a better way to have excel search and select all rows where the value of column A is "Hide" and...

Hi everyone! I have grouped OptionButton1 and OptionButton2//// and TextBox1 and TextBox2 in sheet 1. 1. I want to actively hide rows 10:15 along with TextBox1 and TextBox2 in Sheet 1 whenever OptionButton1 is selected. 2. Additionally I want to actively unhide rows 10:15 along with TextBox1...

Hi, i need vba code to unhide range of rows with password in one sheet and rehide after closing the workbook. thanks,

I’m new to macros and am NOT a programmer. I can use the “Record Macro” function and assign to option buttons to either hide or unhide pretty easily, but I’m struggling to get it to do what I want. I am trying to create a series of yes/no questions where the answer to the first question...

Hi, I want my excel to hide and unhide a row when i select an option from my drop-down list but it is not working. My excel sheet needs to be protected and certain areas need to be locked including part of the row. Here is the code: Private Sub Worksheet_Change(ByVal Target As Range) If...

Hi all, I've done some searching on different forums and can't seem to achieve my objective, I'm also totally new to VBA. I would like certain rows in a column that are "0" to auto hide, but when the cells receive new data and become a value I want the row to auto unhide. The cells in the...

Hi all, i would to provide me support so that, when i enter in cell "I4" the text "MONTHLY" should hide automatically the entire columns "D" and "E" and when i change the text to "YEARLY" should unhide the columns. Thank you all in advance

Hello, I hope you all can help. I have a spreadsheet with dozens of sheets that contain pivot tables. It's based on a year's time with two columns for each month. One for Actual and one for Goal. Because of the way the pivot tables are set up, I need to have columns for each, but I only want...

This has just started to appear as the workbook loads. It continues to load and everything seems fine .. until I try to Hide or Unhide something. Some cols are ok and some bring up the error again. Is there anything I can do to fix it ?

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