Suppose you have a worksheet that contains confidential information, such as employee salaries, that you do not want a co-worker who stops by your desk to … See more WebDec 21, 2011 · and drop down list is in row 12 in cell A12 try this.. 1) Right-click the sheet1 tab and select View Code. 2) Copy the following code. Private Sub Worksheet_Change (ByVal Target As Range) If Not Intersect (Target, Range (" A12 ")) Is Nothing Then Rows ("13:36").Hidden = True Select Case Target.Value Case Is = 1 Rows ("13:18").Hidden = False
How to Hide/show rows depending on a cell value?
WebJul 17, 2012 · Since you haven't shown the code you are using, I'll provide a generic approach which you will need to customize for your use. I added a listbox to a sample userform. This code will selectively hide/unhide depending on which value is selected. WebOne of my favourite tricks is to use the N () function. N () converts a non number to a number but if you feed it text it always returns 0. When I need to add an in cell note to … shantz station road
How to Display or Hide Zero Values In Excel - YouTube
Web2 days ago · Hide null or zero values. This is my first post here. Thank you for considering my questions. Then I have a chart that uses that table, and a table on another page to calculate the data in the table at the bottom of this image. My issue is, as you can see, there are 0's being inserted into months where there should be no data. WebApr 26, 2024 · If I understand you well, you want to show rows 57 to 72 when you select the value of 1 from the dropdown list, otherwise, you want to hide them. I think that the dropdown list in cell B3? Based on that, please try this code instead: Private Sub Worksheet_Change (ByVal Target As Range) If Range ("B3") = "1" Then WebApr 16, 2016 · When you select protect sheet, check Format columns as shown in the image below. Else you can write: Sheet1.Protect Password:="your_password", AllowFormattingColumns:=True Then run your code, hide/unhide should work now. Share Improve this answer Follow edited Apr 19, 2016 at 13:38 answered Apr 16, 2016 at 5:59 … shantz reloading supplies