Over 1 million tech questions and answers.

Excel - Hide/unhide based on defined cells/hyperlinks?

Q: Excel - Hide/unhide based on defined cells/hyperlinks?

Is there a way in Excel (I'm running Excel 2010, but have access to older versions) to hide/unhide cells based on hyperlinks or defined areas? I've hyperlinked so that we could go to specific parts of the document, but that does me little good because we have to hide them or the doc gets to big. Is there a way to have the hyperlink (or the cell hyperlinked) unhide the area? I've attached the document (removed all company info, but the lay out is there) so that you can see what I'm referring to.

I've thought macros, but I'm not sure how to go about it... I did define each area for the hyperlink, so would that be the route to go?

Preferred Solution: Excel - Hide/unhide based on defined cells/hyperlinks?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel - Hide/unhide based on defined cells/hyperlinks?

Read other 6 answers

Hey all

New here and new to VBA so I apologize if this is the incorrect place to ask this question or if I'm not including enough information.

Basically I have two forms, one form that is a cost est. form and another form is a proposal form (client sees this one). I have the proposal form pulling information over from the cost est. form. What I would like to do is on the proposal form if rows c13:c277 are blank (no data pulled from the cost est. sheet) they will hide. But when I add data (a number) into the cost est. form the proposal form pulls that and unhides that row.

I've tried all kinds of VBA code and none seem to do what I want. I can get the rows to hide but then not unhide. I don't have code to show because I have deleted it when it didn't work. Any help would be greatly appreciated.

Read other answers

Hey all

New here and new to VBA so I apologize if this is the incorrect place to ask this question or if I'm not including enough information.

Basically I have two forms, one form that is a cost est. form and another form is a proposal form (client sees this one). I have the proposal form pulling information over from the cost est. form. What I would like to do is on the proposal form if rows c13:c277 are blank (no data pulled from the cost est. sheet) they will hide. But when I add data (a number) into the cost est. form the proposal form pulls that and unhides that row.

I've tried all kinds of VBA code and none seem to do what I want. I can get the rows to hide but then not unhide. I don't have code to show because I have deleted it when it didn't work. Any help would be greatly appreciated.

Read other answers

Hi All,

I have had a look around this site for help and found similar posts but nothing exact or that i can get to work. I'm working on Excel 2010 and i want to do the following unhide or hide a value based on a cell value e.g. -

If Cell "C40" = Yes

Unhide Rows 42 - 47

If Cell "C40" = No or BLANK

Hide Rows 42 - 47

Any help would be much appreciated, I assume this needs to be done in VB by right clicking on the sheet>>Show Code then adding it in. Do you just save then and it should work automatically ?

Thank you

Read other answers


Yesterday I created a code that hides/unhides rows when checkbox is clickedand goes something like this:

Rows("22:24").EntireRow.Hidden = Not Rows("22:24").EntireRow.Hidden

But now i only want to hide/unhide specified cells. So how can i modify the code above to do this or do I need some new code.

Thanks for help

A:macro to hide/unhide cells

"hide/unhide specified cells" - I take it, you mean rows, not cells.

What's your criteria for hiding/unhiding the row? All you need to do is loop through each row in your criteria column, and then program this in as your hide/unhide criteria.

Pseudo Code:


Sub hideAndUnhide()
[INDENT]For Each Cell In Range("A1",Range("A1").End(xlDown))
[INDENT]If(Cell.Value = 1) Then
[INDENT]Rows(Cell.Row).EntireRow.Hidden = True [/INDENT]
[INDENT]Rows(Cell.Row).EntireRow.Hidden = False[/INDENT]
Next Cell
End Sub

If you let me know your data layout, and your criteria, I should be able to make a proper version for you. Even better would be to post your excel sheet with dummy data (remove any sensitive data).

Read other 2 answers

Hello to evrebody,
I have look into the answers and the solutions about "hide/unhide rows based on the cell data" but i am not abble to understand how its work and apply to my sheet.
On theattached sheet i explain what im looking for.
Pleaseo play it and hope to help me and give a solution please.
Thanks in advance.

Read other answers

Good day everyone.
Basically I need to have a formula in excel that includes auto hide and unhide of rows based on the result value. Attached is my sample exercise for quick reference. In this exercise, I want to hide automatically the rows under "REPORT OUTPUT" that contains "0" ZERO value. Basic guide: Once you enter value (from 1 to 5) in cell D3, report output will automatically calculate...... The missing condition in the formula is to automatically hide ZERO value.... Please help.
Thanks in advance.

A:Solved: Formula with auto hide and unhide rows based on result value

Read other 16 answers

Hi there! I'm new to using these forums, but have spent some time scouring them from time to time to look for simple solutions to any excel/VBA problems I'm having. I consider myself relatively intermediate to advanced in Excel as far as formulas and spreadsheet creation goes, however VBA is foreign to me, and an area I'd love to learn. If any of you have recommendations on a good resource to begin learning VBA, please send it my way. And now....onto my macro question.

I've got a workbook with many tabs, and one or two input tabs feed information into another summary tab using various lookup and index formulas. There are any where from 40 to 80 rows to be qualified depending on the specific summary sheet (therefore I will likely need the macro to reference only the active sheet as it needs to work the same way on different sheets independent of each other). What I would like to do is if the result of the formula in column A of the summary sheet is "----------" (starts at A7) then I would like to hide that row, and if the data is changed on the input tab to result in anything other than the qualifying "----------", for that row to be unhidden. If this can be done dynamically that'd be great, however, if a button needs to be put into the spreadsheet to execute the macro, that will be fine too.

Thanks so much in advance for your help, and I promise I'll do my best to begin learning VBA so I can help contribute in return!

A:Macro to Hide/Unhide Rows Based on Results in Column Equation


Here is a code that may help you. You can copy and paste it too a module.
When you copy it to a module you can assign a "Short" cut key to activate the code.
To do this you select "Tool", "Macro" and when you see the name of the macro you want to run you can select it and then select "Options" and assign the short cut key. You will be able to use the short cut key on any active sheet.

Sub Hide_Row()
Application.ScreenUpdating = False
Dim Mysh As Worksheet
Dim cel As Range
Set Mysh = ActiveSheet
For Each cel In Mysh.Range("A1:A" & Mysh.Range("A65536").End(xlUp).Row)
If Not (Mysh.Cells(cel.Row, 1).Value Like "--*") Then
Mysh.Cells(cel.Row, 1).EntireRow.Hidden = False
Mysh.Cells(cel.Row, 1).EntireRow.Hidden = True
End If
End Sub

Read other 2 answers

with regards activex checkboxes in excel, i know you can hide or unhide the said boxes by going to properties and changing the visable section from true to false, can this also be done by using code so if a visable checkbox on the worksheet is ticked this will then display other hidden checkboxes
your help is appreciated

A:Solved: hide unhide excel

Yes, that can be acieved. The best thing to do is attach a copy of your workbook (replace sensitive data with dummy data), so that we all can take a look at your worksheet(s) structure.

Read other 1 answers

I am building an excel model and want to link a macro to the "calculate" button based on the above check boxes. If the boxes are selected, the relevant graphs would need to unhide and show and then hide as the boxes are deselected again.

I've attached a screen shot of what I'm working on.

I would appreciate any help possible on how to write the code for this macro.

Many thanks

A:Excel 07 - Macro to hide/unhide rows

Welcome to the board.

Screenshots saved as bitmaps are huge. Convert them to (e.g.) jpgs, then you can upload without zipping.

Re this part of your post specifically:

Macro to hide/unhide rows

, one "basic" answer is:

Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Rows("11:20").EntireRow.Hidden = False
Rows("11:20").EntireRow.Hidden = True
End If
End Sub

Do you actually have ten charts, or is it far more in reality?

Read other 2 answers

I hid columns D through AN on a spreadsheet. I then realized that I needed some information from column D. Is there a way to unhide one column from a group that you've hid Right now I have to unhide one column at a time to get back to the one that I need. Any help would be appreciated

A:Solved: An Excel Hide/Unhide Question

Press F5 -- type D1 -- press Enter.

Then Format > Column > Unhide.

Read other 2 answers

i am using a userform with a listbox that a user chooses a value, that value is then placed in sheet 15 at cell 29, what i would like is if the value chosen is 6 then rows c6 - c25 in sheet 15 are unhidden otherwise they remain hidden, i have managed to do this before using checkboxes but not via a userform, any ideas for code please

A:Solved: excel hide/unhide on cell value

You need to trigger a macro which can be called from the form.

When a value is chosen, the macro triggered will be something like

To hide:
Range(Cells(6,1),Cells(25,1)).entirerow.Hidden = true

To Unhide:
Range(Cells(6, 1), Cells(25, 1)).EntireRow.Hidden = False

Read other 2 answers

I will eventually want this to work on all worksheets in the workbook as their data may change as the "linked tables" are refreshed. The linked tables are from Access.

What I want to do is look in column Q to see if the result of the calculation in that cell is 0. If so, I want the row hidden. I don't want to hide empty rows, just the one where the calculation =0. If the data in the workbook, i.e. the linked tables are updated, then I want any rows that have changed from 0 to another value to then become unhidden.

I have been searching for VBA code to auto hide/unhide rows in Excel 2007 based on the value in a specific column. I found the following code, but can't seem to get it to work quite right. I changed some of the criteria to fit my worksheet. The problem is that it hides all rows that are empty even though I changed the criteria from "" to 0. Also, this does not unhide rows that may refresh with a value.

I would really appreciate some guidance. My Access and Excel skills are pretty good, but when it comes to incorporating VBA into the mix, I get a little lost.

Sub HideEmptyRows()
'This macro hides all of the rows which are empty, for printing.
'created by Geoff Faulkner 12-29-2004

'Declare variables
Dim intStartRow
Dim intEndRow
Dim intTargetColumn
Dim intCounter

'set default values
intStartRow = 6
intEndRow = 2000
intTargetColumn = 17

'cycle through each row in the range
For intCounter = intStartRow To ... Read more

A:Solved: Excel 2007 Auto Hide/Unhide Rows

Read other 6 answers

I built my pivot table now I would like to be able to hide/unhide certain elements in my pivot table. How do I do this? is there a way to toggle on/off certain elements I want to appear without having to reselect elements for the table?

Read other answers

Hello to all,

I'm new to VBA in general and I'm in need of help in making my project works. I'm currently working on hidden in-sheet menu (rows 2 to 6) that could by unhidden by double-clicking on the cell "D1" and hidden again by double-clicking on "A6". I want to use that menu in every sheets.

I would really appreciate any inputs on this matter. Feel free to view my spreadsheet for a better idea.

Thanks in advance!

Read other answers

Hi guys

Is there a way to unhide the next hidden row (out of all hidden rows in the sheet) based on the location of the button clicked?
Basically what I need is a macro that works with any button (without specifying a concrete name for the button). Based on the row where clicked button is located (there will be cca 15 of them on the sheet), ie row 15, it will unhide next hidden row but leave all hidden rows above hidden.

Hopefully, I didn't confuse you too much.

Thanks a lot!


A:Solved: Excel: Unhide next hidden row based on button position

Read other 10 answers

The iserror or accounting format with no symbol should work WHEN the balance is 0,00 not 0.1972222 or -8.38190317153931E-09. You see this when (F2 and F9) porvides the real value but the cell visually displays 0.

Yeah, I have time on hands to get to this detail.

A:Hide zero cells in Excel 2010 (when result is 0.07)

Read other 8 answers


Got a few questions which tie in to what i am doing so i'll try to explain as best i can.

I want to be able to have excel automatically arrange the order in which it displays the information based on the value or information in a cell. Eg i have a list of things i sell online and I track their performance using the spreadsheet were i have a sheet for every product type which are linked to a master snapshop sheet which has the prices, weight and other info about the items. The product name on this main sheet is hyperlinked to the sheet containing the product and in turn the data in that sheet is formulated back to the main snapshot the aim being as little data input as possible to calculate everything.
I would like to be able to have the snapshop mainsheet automatically put for example the best performing product at the top of the list. At the moment a have to select the cell and expand the data range but this is erratic as i don't think i do it properly. Sometimes it messes all the data up. I am not that good with excel so i am probably going to be told why don't you do this or that etc but that is ok if anyone has an idea.
Anyone able to help?
Apologies if its difficult to follow but i will give more info if requested.
If someone has a link to a webpage that can help would be great also.


A:How do you Auto arrange cells in excel based on their values?

Read other 16 answers

Can someone please offer some code to help me?!

Example of what I want to do:
I want buttons that will allow you to choose the page number(s) you want (1, 2 ,3, 4, or B), and then highlight them green when you click the button. It would be searching the range (K3:DA350), and then highlighting when it finds the value. The cell values in the range consist of
"1,2,3,4,B," "2,4,B," "3,4," etc, so it will have to find the value (1,2,3,4,B, etc) within the cells.

My goal is to offer the user the ability to choose any combination of pages ("1 OR 2"= all 1's and 2's are highlighted, "1 AND 2"= only cells with a 1 and 2 are highlighted, and so on).

What would be really great is if the cells are highlighted green when the button is pressed, and then return to normal when it's depressed.

Thanks for any help you can give!

Read other answers

Is there a way to protect a cell so that its content cannot be changed/moved.

Also, for the same cell, which has a formula, is there a way to hide the formula?


A:Solved: Excel 2007 - Hide formula, protect cells

Select the cell (cells) you wanna protect, rgiht click, Format cells, go to the protection tab, and check both looked and hidded, click OK
After that go to Review Tab, and select Protect Sheet, Type a password if you wanna and save file
Close and reopen it!

Read other 3 answers

Hi All,

So I'm fairly competent in Excel in most things other than macros (which means it could be argued I know nothing about Excel...)

I'm looking for a way to automatically hide rows from a page. Essentially it's a progression tracking sheet that I've got, and I want things to stay on the sheet for only 5 days after the job is complete. I have a TODAY() function which I am using to determine whether or not it has been 5 days since completion.

Any advice would be more than appreciated and I thank you all in advance.


A:Excel: Automatically hide rows based on value

Bumping due to inactivity. Not sure if it's allowed but hey, I still haven't got an answer...

Read other 2 answers

Hi all, long time reader, first time poster. I searched around and have found similar queries to what I require however I haven't been able to adapt these solutions with any success so here we go....

I have a list of businesses in a spreadsheet with information such as name, phone number, e-mail, website, postcode etc. I would like a search box on the side, say in cell O2 where a user can input part or all of a postcode e.g. (LS19 or LS) and those that do not begin with LS would be hidden. The postcodes are in column G.

I'm trying to make this as simple and user-friendly as possible so employees can find businesses in a certain area with ease. Thanks in advance for any help and please feel free to ask questions.

Chris Needham

A:Excel VBA : Hide rows based on cell input.

Seems nobody had the answer so I found a work around myself. Just in case anybody else wants to do a similar thing. Using auto filter is the easiest way.

[SIZE="3"]Sub Search()
ActiveSheet.Range("$G$1:$G$999").AutoFilter Field:=1, Criteria1:="*" & Range("O2").text & "*", _
End Sub[/SIZE]

Where G is the column to search for and O2 is the users input data.

Guess this can be closed now, thankyou all for your help.

Read other 1 answers

How do I hide and show different columns based on values selected from a drop-down list? I wrote a code to do this but there has to be an easier way.

Cell C2 has a drop-down list. This list is from another part of the workbook. Next to the list in the workbook, I put values representing the beginning of the columns I want to Show.

Units 4
Intervals 5
Time 6
All 0

On the page that I am working with I have created a spreadsheet that tracks monthly amounts of Units, Intervals and Time (in separate columns). I want to be able to select "Units" from C2 and show columns, 4, 7, 10, 13... +3 each) then be able to show Intervals (and only show columns 5, 8, 11, 14... etc), then Time (and show columns 6, 9, 12, 15... etc) and if I select All, I want to show everything.

Dim x As Integer
Dim vCriteria
vCriteria = Range("C4")

If vCriteria = "0" Then
Selection.EntireColumn.Hidden = False

Selection.EntireColumn.Hidden = False

Columns(vCriteria + 3).Select
Selection.EntireColumn.Hidden = False
Columns(vCriteria + 6).Select
Selection.EntireColumn.Hidden = False
Columns(vCriteria + 9).Select
Selection.EntireColumn.Hidden = False
'... and repeat til vCriteria + 40 (column AS)

End If
End Sub

This works. But....
There has to be an easier way to write this code. Additionally, I want to be able to add more more columns to this spreadsheet as it is tracking monthly numbers so I don't wa... Read more

A:Excel VBA: Show/Hide rows based on dropdown value

Read other 8 answers

I am trying to hide rows of my worksheet that show a date in the completed column.
The orders that are complete have a date in column F up to this point I highlight them green so I know they are completed but it would be nice if they highlighted green and were hidden when a date was entered into the completed column.
Can someone assist me with creating a macro that will do this?
I am very new to macros so please forgive my lack of knowledge.

I have attached a sample of what I am doing however inf has been changed.

I am using Excel 2007

Thank you,

A:Solved: Macro for excel 2007 to hide rows based on any data entered in a column

Hi, welcome to the forum,

I put some simple code in the Sheet's vba

Make sure you allow macro's to be run

Just enter a date in the last row of column F for testing.

For the other green rows, just click in column F and update the date by retyping it

Read other 3 answers

Hi All,

Is there any shortcut key/command for hiding and unhiding folders in Vista?


A:Hide/Unhide Folder

Welcome Unirock

Hope that this is what you are looking for.

Use Keyboard Shortcut To Show/Hide Hidden Files & Folders

I suggest that you make a system restore point before trying.

Hope that it works.

Read other 3 answers

I have my taskbar set to hide. When I move my mouse to the edge of the screen, it will pop out sometimes and sometimes it is necessary for me to size-down the program that fills the screen, move the mouse to the edge of the screen again and it pops out but goes behind the program that partially fills the screen.

This has me believing the taskbar pops out all the time but behind whatever maximized program is on the screen. This behavior is not restricted to one maximized program and is sporadic.

See screen shot.

A:TaskBar set to hide, will not unhide

Read other 7 answers

Hi there,

may somebdoy please advise (I am pure newbie at Macros):
*I want to create button (I can dot that) and assign Macro to it:
*Copy selected cells (C3:N3)
*Paste values against respective product code (product code can be changed manually in A2)

It happens in the same working sheet (or not a problem if haapens in another sheet)

Many thanks in advance (this would save me some time and efforet)


A:Solved: Copy selected cells to chosen cells in Excel with Macro

Read other 14 answers


I am wondering if there is a simple macro that would allow me to format cells throughout a workbook based on whether they contain an input (ie number/text etc) vs. a calculation (anything with a formula).

Basically I'm looking for an automated way to colour my inputs in blue font and calculations in blank font across all worksheets in a workbook.

Any ideas would be great.


A:Excel macro to format input cells vs calculation cells

I wanted to point out that this can be done without using a macro. In Excel you can click EDIT >> GOTO >> SPECIAL and put a check in the option labeled "Formulas." After clicking OK all your formula cells should be automatically selected on the sheet. Once all cells have been selected you can change the font, background color, etc. for all the selected cells at once. If you prefer to use a macro instead you can try the code I provided below.

Sub FindFormulas()

For Each vcell In ActiveSheet.UsedRange

If vcell.HasFormula = False Then

vcell.Font.ColorIndex = 5


'Replace with your code to execute if cell contains formula

End If

Next vcell

End Sub


Read other 1 answers

Hi Guys

I used unhide.exe after a virus I had... it done the trick.
However, is there an easy way to re-hide all the system files that were hidden before?

Thanks for any help.

A:How to re-hide system folders after using unhide.exe?

Hello, depending on your Operating System you should just need to reverse the change that was made. Look at your system in this guide and put the checkmark back in the box.How to see hidden files in Windows

Read other 7 answers


I have a button that when clicked calls a fucntion "customtoolbar.hidden = true" to hide the custom toolbar. When I wish to unhide the toolbar, I go to view > toolbars, however I noticed that the customtoolbar is still checked and when I click on it the toolbar does not appear!

Any ideas why?

Thank you



A:[SOLVED] Hide/Unhide toolbar


Welcome to TSF!!

If I am understanding you correctly you are wanting to make your toolbars appear and then re-appear. The simple answer the that question is to use the F11 key. That will make all your tool and task bars disappear. Then when you want them back just hit F11 again. I wouldn't bother with all this changing the about:config if you don't have to.


Read other 2 answers

I have two issues that I am banging my head over.

1) I have a page with 4 tables. The top 2 tables each have a link that when clicked will bring up one of the bottom two tables. I have this working now where the bottom tables are hidden until the link is clicked then becomes visible.

The problem is the space is still being taken up by the other hidden table. So if I click the second link, there is this huge gap and then the other table is visible. Any idea on how to not have the gap? I tried using "document.write" but the way I wrote it screwed up the layout.
2) Problem two is similar. I have a form select, that when option 2 is selected I would like to make a table visible. I tried using the same code as the one above with an anchor tag on the second select but it did not work. I then changed it to onSelect and still nothing. Any ideas on how to make a selection make a table visible?

Thanks in advance.

A:Hide/Unhide tables in pages

Read other 8 answers

First Hi,
Second, I'm not sure this is in the right section, my apologize if I made it wrong.

Third, my weird problem,
In Windows Explorer, I have set the option to see hidden files and system files and I do see them. The problem arise when I try to "unhide" a file. I right-click the file and choose "Properties", bottom I see Hide option box, it is checked but also greyed out so I can't "uncheck" it.

Anyone knows why and how can I fix this?


A:Hide/Unhide option unavailable in explorer

I have found part of the solution.

Going through command line I found out that the files were marked as System along with Hidden. I used the command Attrib to remove both and now I can hide/unhide the file. Is there anyway to unflag "System" from Windows Explorer. I don't mind doing it from the command line but would be more "practical" from Windows Explorer.


Read other 9 answers

I am looking for a way to hide and unhide specific files/folders of my choosing. I imagine this can be done via a method or third party program that creates two options in the right-click context menu:
1) Hide selected files/folders
2) Unhide all files/folders

I am open to other suggestions or ways in which this can be done, of course.


A:How do I hide/unhide specific files of my choosing?

Hello Mark,

You could use the tutorial below to actually hide or unhide a specific file or folder.File and Folder - Hide or Unhide
However, when you choose to show hidden files, it shows all hidden files and not just select specific ones. If you like, you could use the tutorial below to be able to toggle showing or not showing hidden files in the context menu.Show - Hide Hidden Files - Add to Context Menu
Hope this helps,

Read other 9 answers

I have my W7 set not to show hidden files and folders.

To show them I go through the usual process , open Windows Explorer then click on the tabs Tools > Folder Options > View and then change to "Show hidden files ...." Naturally have to go through this process again to hide.

Is there a simple keyboard shortcut or some way that I can easily toggle the hiding and unhiding of all folders and files. Not just on individual folders , but have all folders and files that are set to be hidden , to hide and unhide in a simple keystroke.

A:Shortcut to hide and unhide folders and files

Is this what you're looking for?

Read other 8 answers


I want to no how I can hide gadgets from the command line.

I'm constantly frustrated by the fact that the gadgets layout is destroyed when I rotate my screen. So I set a scheduled task to unpack and overwrite the ini file for the gadgets.
But it doesn't work reliably (nothing does with the pathetic task Sheduler). The task doesn't run on time (or doesn't run at all) and such the layout is still broken. So I was thinking I could hide it via command line, restore the ini, then show them again. (With three tasks with a delay, because the task scheduler is garbage and it wont work otherwise, if it'll work at all.)

Read other answers

Hey ya'll,
I have 5 tabs of subforms in Access 2010
Only the first tab is visable.
I only want the rest of the tabs visable if associated checked boxes on first tab are checked.
For example, the check boxes on first tab are:
- Registrant is going to volunteer
- Registrant is a veteran
If those boxes are checked then the associated tab (volunteer info tab) is rendered visable.
I assume this is going to need VB code on either the tabs event, or the first form event, or the check box?
Thank you

A:Access Unhide tabs based on checked box

Yes you need to add some VBA code to the "After Update" event procedures of the Check boxes.
It would be something like
if me.checkboxname = -1 then
me.tabname.visible = true
me.tabname.visible = false
end if
where checkboxname is the actual name of your checkbox and tabname is the name of the tab to be made visible.
The VBA editor should offer you the correct names of the controls on the Form.

Read other 1 answers

I have a sheet with several hundred rows. Starting in Row 4 through the end of the sheet are mixed dates in column 1 and ALL rows from Row 4 through the end of the sheet hidden. I want to be able to type in a date in Cell A1 and have all rows that have that date in Column 1, Row 4 through the end of the sheet to become unhidden. Secondly, I would like to type some other code like "999" or something in Cell A1 to have ALL rows become unhidden. Thirdly, I would like to either type another code or just delete anything in Cell A1 and have ALL rows from Row 4 through the end of the sheet to become hidden again.
Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Duo CPU T6600 @ 2.20GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 3963 Mb
Graphics Card: Mobile Intel(R) 4 Series Express Chipset Family, 1853 Mb
Hard Drives: C: 453 GB (298 GB Free); F: 931 GB (710 GB Free);
Motherboard: TOSHIBA, Portable PC
Antivirus: Webroot SecureAnywhere, Enabled and Updated

Read other answers

Hi! Good Day!

I cant find ways to automatically hide & unhide row depending in G14, G15 & G17. I dont know if it is applicable to Excel. Even if the solution is in other programming language, then its ok to me.

If G14=4 & G15=3 & G17=2 then hide row 28 to 29 & row 36 to 38 & row 43 to 46

I have attach a file for reference.

Thank you so much!

A:Auto Hide & Unhide Rows per data input

This is on the assumption that your rows are not fixed and that your code is AB#.

Read other 1 answers

Alright, here's what I got going on:

I want to be able to have a completely clear desktop, void of icons and start toolbar with a hot key. However, I would like to be able have access to the start toolbar and able to have desktop icons available to me. This is where the hot key would come into play: the ability to hide/unhide both sets (icons and toolbar) simultaneously. Does anyone know of a program or registry hack that would accomplish this?


A:Hide/Unhide Start toolbar & Desktop icons

what is a start toolbar?

there is this for the icons :

clik here

Read other 2 answers

I know about right-clicking the Desktop > View > Show Desktop Icons.

But now I am looking for a HOTKEY to simply hide or show the desktop icons.

I found some instructions on google that seem to work for windows xp but they don't work for me on windows 7.

Do you know of a way to accomplish what I want?

A:Solved: hide and unhide desktop icons hotkey?

Read other 7 answers

I know about right-clicking the Desktop | Properties |Arrange Icons By | Show Desktop Icons. But I do this so many times during the day that I would like a hotkey for this. Preferably one key, not a key sequence.

Do you know of a way to do what I want?


A:[SOLVED] hide and unhide desktop icons hotkey?

Hi Cindy,

My boyfriend needed a solution like what you described and he ended up buying this nifty tool. He loves it:


I hope this helps.


Read other 8 answers

I was wondering if it's possible configure a Windows 2019 IIS v10 hosted Web Server to perform OCSP checking of client certificates that are used to authenticate?

It is my understanding that typically the Responder URL that the Web Server contacts in order to validate the client cert is extracted from the AIA attribute in the client certificate. But is it possible to override/supplement this with an additional Responder?

For instance, what if I set up an OCSP Responder in the same domain as the Web Server and associated its revocation configuration with the SUB CA binded to the IIS Site. Now if client certs come in for authentication  and have an unrelated OCSP Responder
in their AIA, can I somehow tell the Web Server to check also the aforementioned Responder that has been stood up in the domain?

A:OCSP Based Validation for Client Certificates Using Responder Defined by Web Server

Per a reply from Mark B. Cooper at PKI Solutions this is indeed possible. You must edit the following GPO in order to override the default behaviour of the web server which is to only check the Responder URL specified in the client certificates' AIA extension.
Default Domain Policy > Computer Configuration >  Policies > Windows Settings > Security Settings > expand Public Key Policies
Once a custom Responder is specified in the CA / SUB CA's revocation properties the above GPO will allow it to check that custom Responder URL first, then ocsp as defined in the AIA extension and then CRLs
Thanks Mark!
Will post reference links once MS verifies my account.

Read other 1 answers

Dear Brink,

Is it possible to disable/re-enable or hide/unhide Start Menu in Windows Vista via registry, using VB6 or at least disable/re-enable all items in (shortcuts and everyrthing else in Start Menu) in order to exclude starting of ANY program via contents of Start menu in Vista while my own application is active?

Could it be possible to disable/re-enable "Windows" key or any combinations of keys such as "Windows" + "Esc" via registry, using VB6?

Thanks in advance for your help.


A:Disable/re-enable or hide/unhide Start Menu in Windows Vista via registry, using VB6

Hello Vnaz235, and welcome to Vista Forums.

I'm not sure what you mean by the first question. Did you want to stop a startup program from running?

This tutorial will show you how to enable/disable all Windows Key keyboard shortcuts.

Windows HotKeys

Hope this helps,

Read other 5 answers

I have a database that consists of the following:
Col A: case number (e.g. 1993-01-115, 2002-11-078, etc.)
Col B: username (e.g. John Henry, Jane Doe, etc.)
Col C: hours (number of hours each user worked on case number)
Col D: case owner name

Col A contains repeats of some case numbers and is sorted ascending
Col B contains repeats of some usernames

I need to add the hours in Col C depending on:

Each time a unique case number is encountered, check Col D (case owner name) and lookup this name in Col B (username) and sum the hours for each instance the case owner appears.
Database example:
Case No Username Hours Owner
1993-01-115 Jane Doe 2 Jane Doe
2004-05-020 John Henry 1 Theresa Chan
2004-05-020 Theresa Chan 2 Theresa Chan
2004-05-020 Theresa Chan 3 Theresa Chan
2004-05-020 Larry Roberts 1 Theresa Chan
2004-11-072 Andrew Dunn 1 Andrew Dunn

So using the above example, case 1993-01-115 owner is Jane Doe and total hours is 2, case 2004-05-020 the owner is Theresa Chan and total hours is 5, case 2004-11-072 the owner is Andrew Dunn and total hours is 1 and so on.

Could someone help me write a formula to accomplish this? Thanks!

A:How to sum cells based on conditions

Read other 7 answers

Hi All,

Very new to this but have a look at the attachment and see if you can help.

I've used the code

Sub Loading2()
Dim LastRow As Integer

LastRow = Worksheets("Table").Range("A65536").End(xlUp).Row

Sheets("Input").Range("B5,D5,F5,H5,J5,L5,N5").Copy Sheets("Table").Range("A" & LastRow + 1)

End Sub
Sub Supplying()

Dim LastRow As Integer

LastRow = Worksheets("Table").Range("A65536").End(xlUp).Row

Sheets("Input").Range("B5,D5,F5,H5,J5,L5,N5").Copy Sheets("Table").Range("A" & LastRow + 1)
Sheets("Table").Range("D" & LastRow + 1).Copy Sheets("Table").Range("H" & LastRow + 1)
Sheets("Table").Range("E" & LastRow + 1).Copy Sheets("Table").Range("I" & LastRow + 1)
Sheets("Table").Range("F" & LastRow + 1).Copy Sheets("Table").Range("J" & LastRow + 1)
Sheets("Table").Range("G" & LastRow + 1).Copy Sheets("Table").Range("K" & LastRow + 1)
Sheets("Table").Range("D" & LastRow + 1).ClearContents
Sheets("Table").Range("E" & LastRow + 1).ClearContents
Sheets(&qu... Read more

A:Copying cells based on Criteria in VBA


You attached a workbook but I do not see an example as to your request.
Please provide an example a before and after code.

Read other 1 answers


I have a spreadsheet that is generated from another program. I do not know how many rows there will be. What I would like to do is have a macro that will put borders around all cells in a given row if there is content in that row. Particularly, if there is content in say C4, then border A4 through F4. If content in C5, then border A5 through F5 and so on. I do know that there will be no more than 35 rows of data, but I want to start at row 4 with this marcro.

Make sense? Can you help!


A:How to border row of cells based on content?

Read other 6 answers