1. 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...
  2. R

    Button To Hide All Option Buttons

    Hello, I am creating a button that will display all hidden Rows, GroupBoxes and Option Buttons. My code for the GroupBoxes works but I cant get the option button code to work correctly. Below is my current work. Thank you. Private Sub CommandButton5_Click() ' Enter Editing Mode Dim myGB As...
  3. R

    Hide Multiple Option Buttons

    Hello, I am trying to reduce the number of lines of code in my workbook where I am hiding and unhiding a lot of Option Buttons. Is there a way to hide/unhide multiple option buttons in one line? ActiveSheet.Shapes("Option Button 20").Visible = True 'Yes Sub 1...
  4. B

    How do I get a userform to refresh information that changed in the spreadsheet when it is reactivated by userform1.show

    Greetings everyone... Longtime viewer but 1st time poster. Hopefully this will make sense... I have a userform that tracks who gets a project revision when the person the project belongs to is gone (this part works great). In this userform there is another userform that allows me to alter the...
  5. M

    Please help!! Need help with specialized formula.

    Hi everyone, Thank you in advance for your help! <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 142px"><col width="142"><col width="142"></colgroup><tbody> A B 1 10/24/19 =A1+10 2 #b7e1cd[/URL] , align...
  6. G

    Hiding rows with Threaded Comments

    I am using Excel 365 and have a worksheet with a threaded comment. I wish to hide all rows from above this comment to the bottom of the worksheet. If this were a normal comment, now called "Notes", I could format the comment to move and size with cells and this would allow me to hide the rows...
  7. C

    VBA to Hide Rows

    Hello, I am wanting a macro to automatically run when a spreadsheet is opened to check a cell to see what month it is then hide some rows off the back of that. It should look something like the below saying if C5 is one of those months then hide rows 12-18 in the sheet Check List. Private...
  8. J

    Hide rows in range when value in COL A = 0

    Hi All, Need some code to do the following. For a range of rows from Row 10 to 50000 Hide any row where COL A has a value = 0 Many thanks....sorry for such a numpty question. James
  9. B

    VBA Script to hide formula bar - MAC 2011

    Hi Everyone, I'm on Excel Mac 2011 & would like to hide the formula bar via a VBA script. The traditional "Application.DisplayFormulaBar = False" does not work in the Mac version for some odd ball reason. I can hide every other tool bar & ribbon, just not the formula bar. Anyone know of a work...
  10. T

    VBA hide last two rows in a table

    I would like to do a macro that will hide the last row and the total row in a table in excel. Any advice? Thank you!
  11. S

    "Hide Items with No Data" greyed out in Slicer Settings

    Hi All, I'm using Excel for Mac, and am working on my budget. I've created a pivot chart with a slicer for my monthly categories, but would like for the categories with no values for the month selected to be removed from the slicer. I've googled a good bit, and tried unchecking "Hide Items with...
  12. D

    Tipping Competition

    Hi, I am creating a 'Tipping Competition' and I want to make the Worksheets so that after a certain time nothing can be edited by Tipsters. I have managed to hide the Ribbon (so they can't unprotect the Sheet) and I can lock and protect the Sheets as needed. What I can't do is work out how to...
  13. K

    Creating a Hide Button to Hide Rows with Zero in particular cell

    In my previous company, we had a full-time Excel Guru who would do crazy coding to simplify our analysis job and she created an analysis sheet which had prepopulated items which may or may not be useful for a particular project. The ones which are NOT useful will remain zero, and can be hidden...
  14. H

    Hide rows based on data validation dropdown list.

    Hi, I am looking to hide/unhide rows based on a drop down validation. The below codes works for one drop down however I have a further 2 drop downs that need to hide different rows. any help will be greatly appreciated. Private Sub Worksheet_Change(ByVal Target As Range) 'Updated by...
  15. detweiler

    Modifying a macro to hide rows

    So, I had submitted an earlier post, Macro to hide rows ad hoc, in which Peter_SSs helped by supplying me with the following... Sub Hide_Rows() Dim sRws As String sRws = InputBox("Enter rows to be hidden, separated by a colon. eg 5:25 or for a single row just 3") On Error Resume Next...
  16. G

    Hide and Show worksheets

    Hi everyone I have a question in regards to hiding worksheets.. i do know how to do this in the usual manner. although i was wondering is there a way using vba to hide a worksheet, and then show the worksheet if a user clicks on a button, then once the user goes back to the main dashboard the...
  17. B

    Hide tabs and ribbon in Excel with VBA

    Hi I wonder how to autohide the ribbon and tabs with VBA Bengt
  18. I

    Hide combobox entry options please

    Evening, I wish to hide two entries in a combobox. Please can you advise what options are available. The two entries in question must be in the combobox BUT not shown. Deleting these two entries isnt an option
  19. M

    Hiding rows which have a check box

    If I hide rows on my spreadsheet which have check boxes on them, the check boxes do not disappear, they appear to stack up behind each other Is there a way to also hide these check boxes? I am using VBA to hide the rows so a VBA bit of code to hide the check boxes would be perfect! TIA
  20. kelly mort

    Closeup datepicker with VBA code

    I have this datepicker that I have placed on a frame in order to hide it and show it in various instances. Now I am using the "mouseMove " event from a parent frame to hide or show the datepicker. It responded fine. The only issue here is that when the datepicker is opened, after hiding the...

Some videos you may like

This Week's Hot Topics