hidden

I have a file of product numbers that contain both letters and numbers. Some of the products have an apostrophe in front of the first digit (Ex: '71245, or 'P1278) that is only visible in the formula bar when you select the cell. The apostrophe is not visible in the cell when unselected. I want...

Hi, I was wondering about copying what's hidden on one sheet to another sheet. If I hide columns/rows as hidden data, can I copy the info as hidden to another sheet and still unhide the info inside the new sheet? Thanks, Studt#37

Hi, We can Show or Hide a comment using the Excel Menu. Suppose I select a range on my Excel sheet. Say, there are 5 comments in that range: 4 of them are visible (Show comments) and 1 is hidden (Hide comments). How can we write a VBA macro that will count the number of visible comments, and...

So I have a "Tool Bar" across the top of my worksheet that I want to remain the exact same size and position except when row 1 is hidden the tool bar should be hidden as well. If I hide columns etc I don't want the tool bar to change size but I can only seem to get it to either not size or hide...

How can "Recent Places" list be cleared with VBA? I have a hidden folder that I do not want to reveal.

How can one display the value of a hidden cell when a user clicks on the other cell? Say, column B is hiddent. User clicks on cell A1 and B1 gets displayed (A2 --> B2, etc.). Display in any way - pop up, text box or unhide column B and have it visible until user clicks other than A.

Hi - I have a drop down in A3 on sheet1 that lets you pick 1-3. if you pick 1: rows 10-30 hidden, 2: rows 20-30 are hidden, 3: no rows hidden. Thanks!

I have a program that ACW helped me with years ago(pretty sure it was Excel 2003 aka v11, currently on Office 365) that does a look up and converts name to its corresponding item code. This uses a range named "lurange". I am now running into an issue it appears that "lurange" is defined as lines...

Hi there, I have check boxes in column L (L20:L64) which I would like to be hidden, when the row is hidden. Currently all the check boxes are clustering together on L65 when any rows are hidden. The rows start off as being hidden and once data is entered in column B, the row below is unhidden...

Does the parenthesis HIDE in this formula mean the sheet is hidden? I checked the workbook and there are no hidden sheets. Does this mean it's from another workbook? =IFERROR(CONCATENATE("S",VLOOKUP(B2039,'JOB & GRADE MASTER (HIDE)'!$A$1:$C$996,3,FALSE)),"--")

Hi, I use excel 2016. Have a file with very hidden sheets. Need to hide the information on the existence of hidden sheets in my file that excel gives through selecting the "File" tab in the ribbon and then the "Info" section. Any idea if possible and how?

Hi All, I want to hide a row when the value in column A=0. If there needs to be a limit then it would be A1:A1000 with any number of rows that can be hidden. I would also like the code to run only when the sheet is opened. Thank you! Russ

1) Uncheck boxes with Macro Button - I have created a form in Excel which when protected, users can tab through and fill out either by typing, drop down boxes or checking a box. I created a macro button to "Clear Form" but the only thing it won't clear are the check boxes even though I've...

Hello, I have a simple user form that is to unhide a deeply hidden sheet via password. Unfortunately, the hidden sheet is revealed whether the user enters the correct or an incorrect password. Can someone help me adjust my code, please? Private Sub CommandButton1_Click() If TextBox1 = "test"...

I have inherited a file with 200+ hidden sheets, linked and summarized on a "Summary" tab. Every so often I need to unhide 1 or 2 sheets to review, and then re-hide. My problem is, when I right click to un-hide the list is not in numerical order. Does anyone know how to reorder this list? Thanks...

I've inherited a workbook with a bullseye symbol in cell A1. The curious thing is that the formula bar shows nothing in the cell other than a wide space. When I check it with the formula in B1 =CODE(A1), it returns 158. When I enter the formula =CHAR(B1) it returns the character "ž". If I...

I would like to have a certain range visible or hidden. Similar to entire columns/rows, but only the range. Let's say B2:F10 Is this possible? Thank you,

We recently built a spreadsheet containing several hidden and protected sheets. It was built this on Windows 10 PCs running Excel 2013. When someone else opened this spreadsheet on their Mac (I don't know versions of OS or Excel) the hidden sheets were all visible. I've heard a rumour this is a...

Hello, I am working on a to-do list in google sheets and my boss wants some of the information to be private. If the row has HR in column E she wants it to be hidden for everyone except her. I also need everyone to be able to edit the document. Does anyone know how to accomplish this or...

Hi, I'd like to require a password before the button can be "pushed". I'm not great with macros, so I'm really just looking for what I need to add to my current code. This is the macro I have assigned to the button: Sub sHideASheet() Sheets("Sheets2").Visible = True...