hidden

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

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

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

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

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?

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

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

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.

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

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

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

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

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?

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

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

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

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.

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

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

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