hidden

There's a handful of hidden names in my workbook that are killing my attempt to use VBA to copy 200+ Named Ranges to a new workbook. One of them is named "_xlfn.IFERROR" -- it doesn't show up in Excel's native Name Manager, but the Name Manager 4.3 add-in DOES show it (b/c it has the ability to...

Is it possible to format text to white in column A if column B is unhidden but then format the text in column A to black when column B is hidden? All help gratefully received

I have a bunch of macros that run sheets and each one unlocks the sheet, runs, and then locks the sheet. Instead of having the password within the macro code, I'd like for the password to get pulled from cell ("A1") (for example) on hidden sheet ("Developer") so that I can change the password by...

Hi, Is possible to copy a hidden sheet from one workbook to another without unhiding the hidden sheet? I have been looking for a solution to this but can't seem to come up with anything without unhiding, copying then hiding the sheet. Can someone help with this please

Good evening I am using this code: =INDEX(a3:b100,MATCH(L9,a3:a100,0),MATCH(M8,a3:b3,0)) I have a drop down box in L9 listing names, when I choose a name it copies an email address from another (hidden) column My question is this: the email addresses in the original hidden column are...

hi all, as the per the title, is there a way that an individual tab can be hidden and can not be viewed without a password?

Hello All. I found a bit of code here to hide /toggle some rows which was; Sub ToggleRows() Rows("23:37").Select If Selection.EntireRow.Hidden = True Then Selection.EntireRow.Hidden = False Else: Selection.EntireRow.Hidden = True End If End Sub Great!! Works fine,,,,so, on the same sheet I...

Good Morning, As I understand it, you cannot lock/unlock a VBA project with a module. Maybe someone can correct me on this. Here's what I'm trying to do. I have a hidden sheet that can only be unhidden with a password- I'd like a code (if it can be done) that hides the coding or makes it...

Hello, I have written some VBA code to copy cells from a "hidden" Sheet 3 when I click a "Form Controls" button on Sheet 2. Sheet 3 remains hidden, the information copies to the clipboard and I am able to past the information into Notepad or a blank Excel Workbook as a test. The problem is...

Windows 10, Excel 2016, I want to skip over hidden worksheets when running a VBA routine. To skip over the worksheet "TimeSheet2" when it is hidden the code I'm using is; On Error GoTo SkipError_1 ThisWorkbook.Sheets("TimeSheet2").Select More Code SkipError_1: SkipError_1 functions as...

Hi Please help on how i Can paste items if i have a column filtered or have rows that are hidden. I filtered column A, so some rows are hidden, next I want to paste data on the filtered column with out changing the data on the hidden rows. Thanks! Do let me know if it is confusing.

Hi Everyone, Not sure if this is harder than it sounds but i have a range that can have different rows hidden each time. So the range is E:50:M250 now all I want is a macro that can clear the entire range including the hidden cells So I want VBA Activesheet.range("E50:E250").clearcontents...

Hi Experts, I have many worksheet(s) with hidden rows. Now, I need a vba that may help me do following - Select table rows, from Second Row below the Hidden Rows till the Bottom of the Table And then, Sort them in Ascending Oder. All such tables start from Column A of the worksheet only...

Hello Folks, I need a vba code that can help me drag down a formula across filtered cells without a reference to the hidden cells. For example. With cells filtered as follows: A4 B4 A7 B7 A15 B15 A20 B20 The formular will be as follows: A7 = B4 A15 = B7 When I drag...

Hi guys Im completely new to this forum - anyone able to help me with formatting the following formula to exclude hidden row ? =SUMIFS(D18:D100000,N18:N100000,"ADWO") Any help greatly appreciated Thanks Lou

All of my research seems to agree that I should be able to copy the data from hidden columns, but I just can't get it to work. I've tried this exact macro with and without columns E and F being hidden, and it'll only give me the desired result if E and F are not hidden. Background: ws1 is a...

Hi, How do you get a marco to work with hidden worksheets?

I need some help about excel vba. I want to print some specific excel hidden sheets with selected cells range via VBA.for example i"m working in sheet1, and sheet2,sheet3 and sheet4 are hidden so I want to make some buttons in sheet1 for printing those sheets with cell range (A1:N30).so please...

Hi, I tried to copy a set of data from sheet "RawData" which was filtered and paste it at sheet c but there is something wrong in the code line "ActiveSheet.Paste", it says "cannot jump to active sheet as it is hidden". When I click excel help, it says "You specified a name that is in the type...

Hello All, I have a worksheet with a column of incrementing data. The first problem I have is that when I hide rows I want the formula to ignore the hidden cells and continue the sequence. The second problem is that my formula at the moment is inconsistent, For example: -- image removed --...