hiding

Hello, Is there a way to stop a text box from hiding when you are hiding rows that the text box is sitting over?

Hi, Could someone please help me with a pivot table issue. I have three sets of values on each row and I want to hide rows where ALL the three values are zero. Adding a value filter allows only hiding rows where one of the values is zero.

I have multiple cells which have formulas in below Cell AW - =DAY(DATE(YEAR(L2),MONTH(L2)+1,0)) AX- =DATE(YEAR(L2),MONTH(L2)+1,0)-L2+1 AY - =EOMONTH(L2,0) AZ - =DAY(DATE(YEAR(M2),MONTH(M2)+1,0)) BA - =EOMONTH(M2,0) BB - =BA2-M2 BC - =AZ2-BB2 BD - =IF(BB2= 0,0,X2/AZ2*BC2) BE -...

Hi all I've set up a series of button click macros to guide users around an excel file I've built. These are linked to a series of 'storyboard' comments on the data they're looking at. The current process takes users from sheet to sheet, hiding the commentary on the sheet moved from at the...

Hello all, I have a cell range (B5:AE5) that has a gradient fill applied to it. (coloring from the center) all the cells are merged and the text is centered. However at various times, different columns are hidden and then when viewed the gradient is no longer even and the text is no longer...

Hello all, I am having an issue with my conditional formatting. I would like to just manually set all my borders for my worksheet, and have my conditional formatting ignore borders, but when I select no borders it just removes them from my conditional ranges. How do I fix this? Just in case...

Hi, I have a spreadsheet with lots of tabs along the bottom. I have a homepage and I want to have a button that when you press it, you get a list of all the current tabs, and when you click one it will hide that tab. Is there a way to do this using vba/macros? Any help will be much...

Hello All, I have the following code that I have been using successfully for a while now: Private Sub SchedulerPrep() Rows("88:207").Select Selection.EntireRow.Hidden = True Rows("164:196").Select Selection.EntireRow.Hidden = False Rows("164:196").Hidden = False For r...

I just started with VBA and am currently struggling to find a solution to this problem: I understand how hiding works and have code for hiding one range of rows/columns (Worksheets("Sheet3").Columns("A:G").EntireColumn.Hidden = True), but I wanted to be able to store a "list" of column + sheet...

I have a main dashboard sheet that has as many detail-filled individual columns that are respective to the amount of tabs in the worksheet. However sometimes I won't need to see Sheet 32, and therefore, not see Column 32. How can I set up the VBA code so that when a sheet is hidden, so is the...

Hello, I'm not sure if this is possible, but I would like to have a code that when anything is typed into B12 or C12 then row 13 will unhide, then the same thing would happen with B13 & C13 and row 14 and so on all the way through row 30 unhiding. To clarify, if there is any text in either...

Hi everyone- I'm trying to get help writing a macro for hiding columns based on a drop down answer. The drop down would be in cell B7 on Sheet 1. The colums affected would be in each worksheet in the workbook. The data validation would have a drop down selection choice of 1 through 16. The...

Hi. I've spent hours looking for a solution and am not having any luck. I'd appreciate any help/guidance. I have 11 columns in my spreadsheet. In the first, I want to enter a number into cell A1. I'd then like to use a macro to automatically determine how many of the other 10 Columns to...

I have a 2 sheet workbook that is going to be a form for usrers to fill in and send back to me for action to be taken. What I am trying to achieve is when someone selects Add from a dropdown in cell K19 then only the Add sheet is visible or when they select Amend only the Amend sheet is visible...

Hello, I have approximately 40 worksheets which have a table with an identical format but contain varying data results. In each worksheet I need to hide a specific set of rows, but the set of rows I would like to target could be one of four combinations. To start, is it possible to create a...

Hello, I am slightly ashamed to say that I have forgotten the easy formula for this. I need to get the average of G2,G4,G6,G8,& G10 but only those that are visible. That is if I hide row 4, the average would now only include the remaining 4 cells. Thanks, Andrew

Hello all, I am hoping this is a pretty simple thing that I am not getting. I know how to individually hide or unhide a shape in the active sheet, but how would I hide/unhide multiple or all of them at once? Thanks, Andrew

Hi, I've been trying to hide certain columns based on the value of cells in the 2nd row. I have tried the following code, but for some reason it won't hide anything. Protection is not an issue, all sheets are unprotected prior to the running of this code. To state the blindingly obvious myself...

Is it possible to construct a macro to hid all rows that contain "0" in a select column's cells? (All cells in column B that = 0, hide that row - NOT the column, just the row.) Hopefully this makes sense! Anyway, if this is possible, what would the macro be? I can't write (or even record) a...

I am trying to hide columns if their value (in cells BR3:CB3) = 0. If the cell = 0, I would like for the entire column to be hidden. I think I could build an if statement for each individual cell, but maybe there is a way to do a "do while" or "for every"...but I am not as familiar with...