unhide

Hi Everyone, So I have 4 sheets all the same 1 is Data1 data2 etc. (If we could write this macro to run on all sheets called "Data**" that would be great.) NOw data1 is where the data is entered, So what I need is a macro that if any cell in column C of Data1 is changed it unhide the next...

I have created a checkbox with a macro designed to display the rest of the sheet when checked. I have a two-part issue where it is now giving me the runtime error 1004 for the code below. Part 2 is that I need to protect the sheet and still have the macro run appropriately. Private Sub...

Has anyone used the ScrollArea property extensively to limit access to a worksheet? From my limited use, it seems to be flaky, ie if I set it to C:F and say column A is hidden, I have found I cannot unhide it.

I am having an issue with my sheets being locked and using a MACRO transition code to hide and unhide rows by clicking on a circle shape . My Transition code hides and unhides rows 16-17. I would like to still hide and unhide these rows even if the sheet is locked. But currently when i lock it...

Hi. I want to link a macro to a Drop-down to Hide 4 columns to the right of the column the drop-down is found and then to Unhide again. It will act like a toggle button rather than using a button I want to use a drop-down and assign the macro to the relevant source heading. The two source...

Hi, I have several sheets that are I have set to become veryhidden when closing my workbook. I have a macrobutton that I can press, and it will unhide the sheets. Can I somehow create a password that I have to enter when pressing the macro to unhide the sheets?

I started using some code, but it seems to not be deleting all the controls upon exit. Since I have been using this for a little while, many copies of this control are popping up when I hit the application key while an entire column is selected. How do I need to adjust my DELETE code? Thanks...

Hello all, I have a file with multiple pages and which will have two different type of users: 1. the one updating the drivers behind the calculations (mappings sheets) 2. the ones using the final information ( pivot and chart sheets) I am trying to segment the file so that if there is a...

I was wondering if anyone has had dealings with hiding rows? My conundrum is, I have a spreadsheet with 800 rows of data, each row consists of 18 columns and when any cell in this array is selected, I would like to automatically hide all of the rows above the selected row and below it. The other...

Hi, I'm burnt out trying to figure this one out, would appreciate the help. Below is the hide macro (which works) -> Sub Entry_Cleanup() Set Rng = Range("E3:CZ3") For Each cell In Rng If cell.Value = 0 Or cell.Value = "" Then cell.EntireColumn.Hidden = True End If Next...

How to unhide tab on top row in word excel could you suggest me .

Good evening So I have been trying to do this all day. I have tried loops etc. but cannot get my head around how to do this. I am a novice to VBA. I have 2 workbooks What I need to do is compare the values of say row 1 and columns A to BN1 in say sheet 1 in Workbook 1, and if the value is...

The reason I ask is because a user of one of my workbooks called me and said he could no longer see the sheet tabs. I simply went to Options and checked the box for "Show Sheet Tabs" but I was wondering how he hid them. I know he didn't go to the Options and un-check that box... so is there any...

I need to Hide Columns based on Cell value. I have tried using VB codes supplied on this forum and get some of it to work but not all. Please see below Value in Cell D1 and the columns that need to be hidden based on this result: <tbody> IQC - F,H,I Factory Flash -F,H,I Build Test -...

Hello, I am creating a report and looking to make a macro that will hide rows if there are no values in column H of that row. If the number in column H is positive or negative I would still like that row to be visible. How would it be possible to create one check box, so that when it is...

i need macro or whatever solution you people have for the following situation: in the range g219:gd219 have 0 in that row then hide the column in which that cell is located which have 0, e.g if m219 have value 0 then hide column m and when value changes from 0 then automatically show column back

Hi, So i'm struggling to get the correct code to allow me to hide/unhide the rows in my spreadsheet dependant on value. In column F i have the option of Y/N and would like my spreadsheet to automatically hide something that has Y selected dependant on the value in column G and unhide anything...

Hello everyone! I really need help in auto. hide & unhide rows 5:3666. This worksheet is named Feed Sheet & it is also a pivot table. I have a report starting in row 3667 from the data above in the rows 5:3666. I need for any rows from 5 to 3666 to hide/unhide based on any data entries in those...

Hi Everyone. I'm completely new to VBAs but I'm trying to combine a button to do two things. I have several worksheets (Main, DataSheet1, DataSheet2, DataSheet3, etc.)... I also have several rows on different worksheets (rows 16-28 on ExcelSheet1, rows 10-15 on ExcelSheet2, rows 9-13 on...