1. fnijkampnl

    properties of tab greyed out when closing

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

    Toggle Button to Hide/Show Data

    🤓 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...
  3. E

    Excel VBA Based on filter value, only show columns ...

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

    Hiding the leading apostrophe

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

    How to unhide hidden rows and columns?

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

    Good way to hide rows?

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

    Hide/Show rows in a different sheet based on Yes/No responses

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

    Hide - Unhide

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

    Hide Excel Toolbars, Ribbon, etc. in a file i'm opening without messing up any other open Workbooks

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

    VBA Help for Hiding rows from a data validation list choice.

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

    How to Hide/Show Tabs off list in workbook

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

    VBA to hide rows based on multiple criteria

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

    How to hide VBA Code on a Protected Sheet?

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

    How to suppress ActiveX checkboxes based on a macro

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

    VBA Macro Column Hiding

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

    Loop Shapes and Hide if Value/Text is Zero

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

    VBA code to remain in the same page while running the macro

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

    Masking password characters in VBA code

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

    Hide / Unhide tables based on a list chosen

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

    Hide Scroll Bar in Sheet

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back