hidden

If you a have sheet that is filtered, and hide columns, then sort (via any viewable column), does the hidden columns also sort? I have a fairly sizable file (12k rows, 37 cols; several columns are for me) that I want to send to a few team members to sort/verify/update their data. I'm...

Hi all I'm new here and kinda of new to VBA, but trying to learn. I have a bit of a tough one (for me at least). I am trying to write a code that can do the following. Whenever a row is hidden manually if the row contains a value greater or smaller than zero, and not text string in...

Hi I have a double-click event that copies a cell on the same row as the Target but that lies within a hidden column. It won't copy and I'm wondering if there is a way of forcing it to copy. I've searched online but can't find anything that really fits my issue. Thanks in advance, Liam

I am trying to get the below to work in columns that are hidden from view in Excel. It does work, but only if the columns are not hidden. Is there a way around this? With Sendrng .Parent.Select Set Rng = ActiveCell .Select ActiveWorkbook.EnvelopeVisible = True With .Parent.MailEnvelope For Each...

Hi all, I have the following code which is supposed to add "N/A" to cells and colour them in green: If ch = vbOK Then Target.Cells.Interior.ColorIndex = 43 Range(Cells(Target.Row, twelvewl + 1), Cells(Target.Row, twelvewr)) = "N/A" Range(Cells(Target.Row...

I have about 90 worksheets in my workbook. About 75 contain sensitive financial information that I don't want available when someone is sent the file. Is there a way to "group" the 75 sensitive worksheets so that with one click of a Macro button, all 75 worksheets are hidden with a password...

I am trying to copy a row in a table that includes some hidden date. I want to be able to past the row below creating another row in the table. When the columns are hidden I want them to also be copied and pasted below. How can I make sure that all my data in that row is copied including the...

Greetings. I have a spreadsheet to calculate incentive pay based on title. The title is pulled from a data validation list in cell F7. There are 10 possible titles and when selected, i want a variety of ranges of rows to be hidden. The hidden rows may be different for multiple titles. There...

Hello all, Avid consumer of Mr Excel, first time poster. I am building a sortable data table that I want to include images into. I have pasted them into the corresponding cells and when I use a slicer to filter the table, everything works, images move accordingly BUT the images that should be...

Hey everyone, I am trying to Copy data from one sheet and paste it into another. I want the rows that are hidden to stay hidden when they are being pasted instead of reappearing. I am guessing it is a Paste option, but I don't know which one. Thank you in advance. Here is my code I am using...

Hi all, Here is some code that I am using to hide columns in my sheet labeled as "Finished". I have a button copy and paste data into my "Finished" sheet, but these hidden columns keep on appearing when they aren't suppose to. The columns are hidden, because they do not apply to what is being...

I’m pretty new to vba and am have a workbook with 40 tabs that have a lot of calculations. I created a couple of summary sheet for the 40 tabs but it takes a while to calc. I tried to use the code below in the individual worksheets that I want to hide, but got an error. Private Sub Calc()...

Hello guys, I'm new to this forum and I wanted to say that English is not my native language, so if I make some mistakes, please forgive me. I'm trying to create a fitness related Excel "software" but I have some problems with hyperlinks. In the workbook I have one main tab (named "Intro")...

hello I have four named ranges tcd1, tcd2, tcd3 and tcd4 which are all hidden when user opens sheet What I would appreciate is vba code (if it's possible) when the user clicks macro button code checks tcd1,2,3 and 4 for their hidden/unhidden status and unhides one of the hidden named ranges...

Hi there, Can somebody please help amend my macro so that it ignores hidden rows? I have been playing around with some code but have not got it quite right. I know it is an easy fix I am just a noob. Here is what I have so far: Sub Selection_Uppercase() For Each x In Selection...

Hi All, I need some assistance. I'm VERY new at this. I've created a report, where I use data from Sheet 1 to populate some of the cells in Sheet 2, column B being one of them I'm not sure how I want to go about this. But I want the row to be hidden if the B cell is empty on Sheet 2. So if...

Hi there, I am looking for a macro that I can use o unhide sheets in a workbook. I want to have three button in sheet1 for sheets 2, 3, an 4. Sheets 2, 3, and 4 will be hidden and depending n which button we click on in sheet1, they unhide. Also, when closing the workbook, I do not want to...

Is there a Macro that will unhide all the Very Hidden Sheets in the Workbook?

I have a workbook which has 100's of hidden sheets. I need to be able to hyperlink to a hidden sheet which may also contain a hyperlink to another hidden sheet. I have trie to use the following VBA code but it doesnt work on the newly opened sheets Private Sub Worksheet_FollowHyperlink(ByVal...

I'm looking for a way to keep data hidden in a sheet. I have used the group outline tool and the hidden columns tool. What i have discovered is that even if I protect the sheet, another use can right click on the sheet and copy the sheet to a new sheet. And then have access to the hidden data...