1. 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...
  2. 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...
  3. 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...
  4. 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
  5. 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...
  6. 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!
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. B

    Hide tabs and ribbon in Excel with VBA

    Hi I wonder how to autohide the ribbon and tabs with VBA Bengt
  14. 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
  15. 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
  16. 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...
  17. G

    Cannot shift items

    I have a worksheet and wish to hide the rows below the last used row. When I select all rows to the last row (52:1048576)and try to hide them, I get the illogical message "Can't push objects off the sheet". I have searched for objects and there are none on the sheet. I'm using Excel 365. Has...
  18. R

    Hide Another Workbook Worksheet

    Hello Everyone In A1 i have a path d\temp\action.xlsm Action.xlsm Workbook has a worksheet by the name of secret Right now in current open active workbook.. name sample.xlsm. i have a button. I want if i click on that button action.xslm worksheet would be hide. In simple i want to hide...
  19. U

    Hiding columns beyond column Z

    I need to hide all columns beyond column Z using VBA
  20. D

    Filtered dataset / sort / hidden columns

    If you a have sheet that is filtered, and hide columns, then sort (via any viewable column), does the hidden columns also sort? I have a fairly sizable file (12k rows, 37 cols; several columns are for me) that I want to send to a few team members to sort/verify/update their data. I'm...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...