1. B

    Hidden Excel 4.0 macros can't be removed

    I use Excel 365 on Windows 10. I have a Membership database in an Excel workbook. Every so often, using a VBA macro, I copy a worksheet into a new book, remove all code from the copy and update various cell formats. I manually do some editing and remove some rows and columns and then run a...
  2. P

    Excel 2019 mac. Userform not visible in VBA design mode

    I have just upgraded from Excel 2011 to 2019 I have a VBA project that includes 2 user forms. In 2011 when I double clicked on the form name it opened the form in design mode and let you add command buttons, delete them, position, etc. If you then clicked on one of the items it opened up the...
  3. B

    Vb msgbox with hidden named ranges

    Hi, I’m new here. I figure I’d get that out of the way right away. I’m also relatively new to the concept of implementing VB into my excel worksheets. I maybe a bit more than a novice but not by much. So my issue what I’m trying to attempt, is I have a worksheet with multiple drop down...
  4. R

    CommandButtons not working.

    Hello, I have a Navigation tab in a workbook that has buttons to take you to specific sheets. I have written code so that when the "Plastics" option button is selected columns I:Q are hidden and all buttons within those rows are hidden. Private Sub OptionButton2_Click() '''''''Plastics...
  5. A

    VBA hiding passwords in code

    I have a hard coded password in my macro, but I don't want it to be visible if someone chooses to go look at my code. Is there a way to have it hard coded and hidden from view?
  6. R

    Hide Rows without a value

    Hello, I am trying to write a code that: Looks at cells in column A from rows 9:100 -If a cell does not have an integer then that cells entire row is to be hidden. This is what I have so far. Thank you. Private Sub CommandButton7_Click() '''''''''''''''''''''' Question Rollup Dim x As...
  7. A

    vba hidden columns

    Is there a way to make this easier? Less wordy? Columns("B:C").EntireColumn.Hidden = True Columns("F:G").EntireColumn.Hidden = True Columns("J:O").EntireColumn.Hidden = True
  8. R

    Opening Hidden Columns in Excel Sheet

    I tried to open an old Excel sheet, and columns A through AM were hidden. I cannot open the hidden columns by using the Unhide action (highlighting the entire sheet). Any suggestions that would enable me to open these hidden columns would be appreciated. Thanks.
  9. D

    Some advice

    Hi all, I'm after some suggestions. I am currently putting a worksheet together at work that will show various bits of data. Some data is pulled onto the main sheet from a hidden sheet when I put their employee ID into a cell. If their telephone number is stored on the hidden sheet it will...
  10. P

    EXCEL shapes.visible won't work anymore

    I have the following code. It used to work on this spreadsheet but no longer works. ThisWorkbook.Worksheets("Sheet1").Shapes("Terminator").Visible = True I know there is nothing wrong with the code because I made a brand new spreadsheet and tested the code and it works. However, there is...
  11. T

    How to change code to and

    Private Sub Command43_Click() 'Admin Button Bring back nav and other views that are hidden If Text9.Value = "tam.badal" Then 'UnHide the hidden objects in the navigation pane Application.SetOption "Show Hidden Objects", True 'UnLock navigation pane...
  12. K

    access to hidden sheets

    I have A combo box named comboWs that has a list of all 63 worksheets in the workbook, but all are hidden except the active one. Combo's output is on worksheet named general.switchboard in cell "O54" (this worksheet is visible=true). I want to go to the worksheet selected in the combo. I've...
  13. R

    Remove commented lines

    I have an excel spreadsheet containing many rows copied from VBE. Some of these contain comments - always with a ' in column 1. I would like to delete these lines, but the ' is a hidden character and the program can not find it. Any suggestions, please?
  14. gheyman

    Access: Keep Navigation pane closed

    Is there a way to keep the navigation pane closed or keep users from accessing it without proper permissions?
  15. T

    Apply colour to frozen table header when rows hidden

    Hi All, Silly question(s) time again. I have frozen rows 1 to 4 which contains the table header and other details. What I would like to do is have Row 4 cells fill with red when the user scrolls down. My reasoning is it will help remind the user there are hidden rows. So my questions are...
  16. L

    Losing my mind over "call" macro

    Hello all. I have a macro that hides and unhides several rows on a sheet, and works perfectly when on I use a button ON THAT SHEET. I have another sheet that has a checkbox that when selected, should run the exact same macro and for some reason it only runs half of it. I'm losing my mind, can...
  17. J

    Can't Edit Macro From Personal Workbook

    When i try to edit macro it says can't edit macros from a hidden workbook. The workbook in XLStart is not hidden. I've also checked to make sure it's not in the disabled add-ins list. If i click in macros and hit run the macros will run. But i can not edit them to assign a shortcut key.
  18. muhammad susanto

    Average With Data Hidden NOT WORKING

    hi all.. <tbody> data1 data2 data3 (Hidden) data4 data5 10 5 20 12 15 </tbody> how to use average formula with data hidden column.. i have use average or subtotal but not working. i'm use ms office 2010.. how to figure out this? I want can work for 2 condition, visible column or in hidden...
  19. U

    Copy paste block with hidden rows

    I need to add code to a macro to copy and paste a block of cells that include hidden rows of data, sample code Selection.SpecialCells(x1CelltypeVisible).Select Copy Range(A4:B10).select Application.CutCopyMode=False Range(A4:B10).select Selection.PasteSpecial Paste:=x1PasteValues...
  20. Q

    Making Conditional Formatting ignore hidden rows

    I have a document with multiple filters that cause multiple rows to be hidden. The visible data looks similar to this: <tbody> Column A Row 1 15 Row 3 24 Row 4 13 Row 5 32 Row 11 12 Row 13 20 </tbody> I am trying to create a conditional formatting to highlight the highest 3...

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