1 Unhide Excel Rows Based on Cell Value 1 Speed up Hiding/Unhiding rows based on criteria 0 Faster way of hiding rows in vba 4 Faster VBA to hide rows 0 Making VBA code in Excel to show and hide rows more efficient? 1 Improve speed on Macro hiding rows 0 Hide Rows based on...
the rest need to be locked, but readable. I have code that hides/unhides rows based on a cell value in that sheet. It works fine. But when I go to set up the cells the user can access and then protect the sheet, it won't work. I can't find a work-around. Anyone...
I need the process of hiding rows based on the condition of existing text on yellow cells. As I said before, I have three pages in the “Sheet1” of the "test3" excel file, I need to create four buttons to: Button 1: displaysPage 1 only and hides blanks cells "if found" based ...
[powershell] Help Deleting Rows in an excel document [PowerShell] How to change Windows 10 default web browser to IE using PowerShell? [Powershell] lastlogondate exactly 90 days ago [SOLVED] Domain Join Assistance: Account Already Exists [Solved] Exporting profile photos from Office365 [SOLVED...
What I really want to do is "hide" and "show" pages based on who logs in and what rights they have. If I remove the page then I have to completely rebuild it if I want it selecyted (currently have 12 tabs).I've been looking at you web site but I don't see what I need...
Hello! Seeking guidance on how I can hide rows in a pivot table if the value in a certain column is zero. Overview: I have a data dump from an...
(rng.Value) = "complete" Then Set trg = Worksheets("Sheet2").Range("A" & Worksheets("Sheet2").Rows.Count).End(xlUp).Offset(1) rng.EntireRow.Copy Destination:=trg rng.EntireRow.Delete End If Next rng Application.CutCopyMode = False Application.EnableEvents = True Application.ScreenUpdating...
@HansVogelaarfollow up question - i am now trying to hide rows based on the value in column A (i've added in page numbers in column A and i want to hide all rows with a page number greater than the value in Cell P3. I have tried to use the same code you provided for ...
If Triggercell.Value = "Code 1" Then Rows("22:58").Hidden = True ElseIf Triggercell.Value = "Code 4" Then Rows("22:58").Hidden = True ElseIf Triggercell.Value = "Code 2" Then Rows("22:32").Hidden = False ElseIf Triggercell.Value = "Code 3" Then ...
This will be an end-user spreadsheet. There are certain cells they need to access, the rest need to be locked, but readable. I have code that hides/unhides rows based on a cell value in that sheet. It works fine. But when I go to set up the cells the user can a...