show/hide

VBA noob so any help is much appreciated as I have tried but failed to do this. I am using the latest version of Excel. I need to be able to show/hide project rows depending on the value a user enters into a cell from a drop-down list in row 2 at the top of column in question. My sheet has a...

Hi All, I cannot seem to figure out how to get this code to work multiple times on the same Worksheet (I am definitely a beginner when it comes to VBA). So much so, that an awesome member helped out on this forum with the below code to hide and show rows (2-43) based on a number entered into a...

I have set up a comment on a particular workbook, but when right clicking on the cell containing the comment, the show/hide comments does not appear on the menu when right clicking I works on my other workbooks It would be appreciated if someone could assist me in resolving this

Here's my scenario: I have a combobox with 4 values and 4 rectangles named after the combobox values. When the value is selected from the combobox, i want the appropriate rectangle to become visible. If the value in the combobox changes, I need the visibility of the rectangles to change...

Hi all, I have successfully added in a number of show / hide macros attached to buttons in order to manage the visibility of various rows / columns in an Excel 2010 spreadsheet. Over time, as more data has been provided it has become necessary to insert additional columns or rows into the...

Dear all, I looked up several posts within this and other forums but I cannot get my code to work. One of the reasons might be that I am absolutely VBA-naive ... Here is the simple problem: I have a drop-down (via Data - Data validation - list) in cell D8 of a Excel 2013 work sheet. I inserted...

Hi, I have four buttons in my excel that show sheets using macro. The button works in the below way: D1 - Shows Sheet1, Sheet 3, Sheet 7 D2 - Shows Sheet2, Sheet 4, Sheet 6 D3 - Shows Sheet5, Sheet 8, D4 - Shows Sheet D9 For now we have hard-coded the values in the code about which...