hidden

I have a spreadsheet that has confidential information. I know how to lock the sheet and hide the confidential info that is not the problem, What I want to know is there a way to have two levels of security. Two different passwords to open more or less. Some people need to see the confidential...

Hi there, I've got an idea but I don't have the technical ability to write it nor do I know if it's possible. Hiding rows based on a change of a formulated cell is not easy to do. In this particular example though, the data is manually entered up top and summarised down the bottom by formulas...

I've copied and pasted my data around my workbook that many times and this is now the dilemna that I have... If I highlight the first column of data, the count (bottom right corner of the screen) is saying 1439 which is the amount of records I want... However, if I copy and paste that column...

Hi folks, hope you can help me. I am using Microsof Excel for Office 365 MSO (16.0.11029.20104) 64-bit. I am trying to create a shared expenses spreadsheet, using the template from this tutorial www.exceltactics.com/how-to-split-bills-and-share-expenses-using-a-free-excel-spreadsheet/ - I...

I have a print button setup in sheet1 which is a form control attached to a macro that will printpreview sheet2. It works just fine when the button is pressed but only if sheet2 remains unhidden. if possible I'd like for this button to work even if sheet2 is hidden and will not u hide it when...

Dear Sir, I am using following code to add rows from A5:A498 It add rows in a way like, It unhide Row: A9:10, then A13:14 A11:A12 keep hidden, same way it goes all the way to A498 Sub addrow() Dim Ar As Areas Set Ar = Range("A5:A498").SpecialCells(xlVisible).Areas...

I downloaded a spreadsheet from another software program. In that spreadsheet I have a formula that references a cell to the left of the cell with the formula. The formula does not calculate properly because there is a hidden value in the cell being referenced. When I press the delete button...

I have a set of date - lets say Cells A1:A300 I need to transfer this over to a different file/template that I can not change. This template has a row then two hidden rows then a row then two hidden rows....etc. So if I select A1:A300 and copy then paste it over to this template, it pastes...

Hi Why datedif() is hidden function? are they other functions hidden? Thank you very much.

Hello, I am trying to figure out a bit of code which will fit into a much larger module. Basically I have an Excel Table, for which the Header Row is in row 6. The table may or may not be filtered. I want to be able to find the row number of the 25th visible row (even if it is blank and...

Hello All, I believe I know the answer to this already...but any way. I have a hidden tab. I have a cell which links to the hidden tab When I click on the hyperlink to open the hidden tab, it doesn't "show", because it is hidden Question: Is it possible, without VBA, to unhide the tab when it...

I have a simple lister to put information onto a page Dim I For I = 3 To Sheets.Count Cells(I, 24) = Sheets(I).Name Next I I've tried eliminating a number of sheet names, that are usually hidden Master and Data Page and Times anyone point me into how I can exclude those...

Hi all, I am opening a file from a shared network drive that when opened automatically gets hidden. This only started a few days ago and only happens to me and not other users of the file. Does anyone know how this could happen and how I can stop it ? I don't know much about VBA but there...

While filling out an online form, new hidden fields become visible depending on the options you have previously chosen. My question is: Why do these hidden fields become visible while filling out the form manually (selecting and clicking the mouse in real time) but NOT when filling out...

Hi Everyone, I'm getting a bit confused and need help (so my friends keep telling me :-) ) I have a workbook and want to create a new sheet using vba if the sheets not already there but the sheets are hidden? so any ideas how i can do this? lets say the sheet is called "Tony1" Thanks Tony

I have some hyperlinks that go to hidden sheets on my workbook without issue. But I have a if the statement that works when the page I am hyperlinking to is not hidden. I would like it to work when it is hidden. the if then statement is =IF(EXACT(B7,"Vanco"),HYPERLINK("#Vanco!B2","Click for...

I 'm using the below code to copy a hidden sheet and rename it. It works fine if there is only one hidden sheet but i will have up to 20 hidden sheets. Any help will be appreciated. Sub AutoAddSheet() Application.ScreenUpdating = False Dim LastRow As Long, MyCell As Range LastRow =...

How to prevent a hidden column in excel from revealing?

I'm using the code below. If I only have one hidden sheet it works fine. but i have multiple hidden sheets abd at that point it no longer functions properly. Please help. thank you, Sub AutoAddSheet() Application.ScreenUpdating = False Dim LastRow As Long, MyCell As Range LastRow...

Dear Sir I have a worksheet which has following sheets; Sheet1, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6 All these sheets have buttons "back" and "next" I have hyperlinked this to next and back sheet but what it want is that; Once I press "Next" on sheet 1, user jumped to Sheet2 via hyperlink, at...