hide

Hi, I didn't do a search for this problem because I do not know how to make a correct search argument. That is all answers were about something else. This is the case. In my BeforeClose procedure I did a VeryHidden on all tabs and a show on a tab with a warning. The warning stated that the...

🤓 Good day my fellow nerds, I need help so I came here to see what Master Nerd could be so kind to solve this issue I am having. What I am trying to do: I'm trying to have a toggle button to hide/show date historical's on a Tracker. There is a tracker I have that I am looking to use...

Hi all, Currently I am looking for a clever way to hide columns based on a value in column E from the below example. I have already looked for some ideas but can't find the exact one I am looking for. As you can see, the following sheet contains a lot of columns, the user is overloaded with...

I have zip codes which should have leading "0's" but excel automatically eliminates leading zeros. I realize that I could format the number to display 5 digits thus forcing a leading zero to appear. But that is just formatting and does not actually add a zero to the number. I want the...

Hi all, This may seem super simple and silly to ask, but I have currently made this setup: I have hidden EVERYTHING except for rows and column 1-7. However, I would like to unhide row 8-10 now, but I have no idea how? When I click on "7", which is the closest row I can currently touch, and...

Hi all, I have an overview like this: I am looking at four quarters for a year. I have a filter as well. I want to specifically hide the first three quarters somehow. However, please note that: 1) I cannot use a filter, because I often use a macro that wont work if a filter is on, and 2) I...

I am trying to build a macro that will hide or show a group of rows in the Options sheet (shown below) based on the Yes/No responses from the Questions sheet. Essentially, someone will fill out the Questions sheet to narrow down what they actually need to see and then further define their needs...

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

Hi guys, I'm using the following code to hide all bars and open a workbook to give an app feeling look. I'll call it my EXCEL APP STYLE FILE from now on. Code i'm using to hide all the stuff and define the width and height is the following: Sub UIHide() With Application...

Running Excel 365. Windows 10 machine. So I think I have a few issues to sort out, I am working on a spreadsheet that will change the rows available to show (fill in) by 2 variables. I'm creating an Address Matrix for a programming file on another type of system and there are 2 versions of...

Hi All, Need alittle help. Would like to create a macro that will either Show(S) or Hide(H) workbook tabs based on a list in a separate tab. So in a nut shell if Column B is "S" Show Tab in Column A. If Column B is "H" then Hide Tab in Column A. Can any of you wise guru's help me out? Thanks in...

I can't download your add-in due to work IT restrictions, sorry. I'm trying to hide rows too and I know I'm doing something wrong. If the values in $i3, $J3, $O3, or $Q3 =0 then hide row, if not then don't hide row. then go to the next row in file. I have this: Sub HideRows() StartRow = 15...

I am using code to add a double line that requires me to set the same password as the password to protect the sheet. And I don't want someone to be able to view the code on my protected sheet. How do I do this? Also, I don't want to hide the sheet, just protect it. Here is the code, if needed...

I have a macro that I'd like to use to reset a form to original conditions - All rows/columns shown - Cell updated with today's date - Background colors reset - Clears contents from multiple ranges I'd like for this same macro to hide lines and the checkboxes within those lines. This section...

Need help if anyone can provide it. I'm trying to write a Macro where i can hide columns based on a cell value. The issue I'm having is trying to figure out how to construct it in a manner where I can have the macro work based on multiple cell values as well as work throughout the entire...

I am trying to create a sheet to print scales and chords for guitar students. I am having trouble hiding shapes on the fretboard based on the value within the shape. There are 224 shapes on the worksheet. Each shape is linked to it's own cell on a separate sheet. I figured out how to hide a...

I have a VBA code with multiple subs and it has multiple worksheets which will be hided and only macro worksheet will be visible. when someone runs the macro it will unhide the other worksheets and exports the output then at the end it hides the worksheets. problem is at times towards the end...

Dear Mr Excel, I have created a password activated spreadsheet, but I cannot find how to 'Mask' the characters of the password box, does anyone know how to help? I have created the code below; Sub Run_Password_Admin_Macro() 'Password protect for Admin Dim strPassTry As String Dim...

Hi all, I’ve got a sheet with 4 tables on it. I have a cell in B2 with data validation set to a list on another sheet. I can currently hide or show the tables based on either columns or rows. As one table is shown the others are hidden. What I’m wandering is if it is possible to hide or...

Hi, Hopefully this is possible. I'd like to hide the horizontal scroll bar in a specific worksheet. The code below does it generally for all tabs, would appreciate some help tailoring it to only apply for the "Results" worksheet Code - For All Sheets: Private Sub...