Unhide Rows - Spreadsheet Not Protected

May 24, 2014

I've a few rows that are hidden, and I cannot unhide them using the unhide function. The spreadsheet is not protected. What can I do?

View 5 Replies


Allow Hide & Unhide Column/Rows On Protected Sheet

Sep 25, 2007

I'm familiar with the code to allow grouping/ungrouping in a protected spreadsheet; http://www.ozgrid.com/Excel/outlining-protected.htm. How would I code to allow for hiding/unhiding cloumns and rows while still protecting the spreadsheet? Also, how could i allow for this file to be shared? Currently i'm getting an debug error when another person enters the file.

View 2 Replies View Related

Hide / Unhide Columns On Protected Sheet

Feb 20, 2008

When my spreadsheet opens it automatically protects the sheets using the following

With Sheet1
.Protect Password:=SpreadsheetPassword, UserInterfaceOnly:=True
.EnableOutlining = True
End With

and I use the following to hide the column if the toggle button on my form is 'true'. The problem is it gives an error if the sheet is protected. it worksfine without protection.

If ToggleButton1.Value = True Then
Range("column_calories").EntireColumn.Hidden = True
Range("column_calories").EntireColumn.Hidden = False
End If

View 7 Replies View Related

How Do You Allow Hide/unhide Or Group/ungroup Features While Protected

Dec 20, 2007

We have a file that needs to be updated monthly by running macros, but the macros are being blocked by protection. I would like to put some code at the start of the macro that unlocks all sheets and then at the end locks them up again. Actually, all I really need is a macro to do just that unlock all sheets, and then another one that locks them back up again as we will need to lock and unlock at various times and it is annoying to have to do it by sheet ....

View 14 Replies View Related

Cracking Protected Spreadsheet Other Than Copying Tab And Pasting?

May 29, 2012

How do you crack a protected spreadsheet other than copying the tab and pasting? Someone protected a lease abstract by mistake and now we cannot make changes.

View 1 Replies View Related

Pop Up Textbox In Data Validation In Protected Spreadsheet With Certain Constraints

Feb 17, 2009

This is the code where you click on a cell that has been input from Data Validation, it gets a pop up textbox showing the text input. One drawback I see here is that when the sheet is protected, one needs to tick 'Edit Objects' in 'Allow all users of this worksheet to:' window to get the textbox to pop-up otherwise no textbox is shown.

So this leads to the accessed user to have the ability of deleting and moving the textbox in the protected spreadsheet. Do you have any idea to Protect the sheet, Get the textbox to pop up,
Disallow user to delete/move the textbox.

View 10 Replies View Related

Unhide 2 Rows At A Time Starting With Rows 28 And 29?

Aug 20, 2014

I need to unhide 2 rows at a time starting with rows 28 and 29 IF cell N28:O28 > 0. I need this to be for rows 30 and 31 IF cell N30:O30 > 0, rows 32 and 33 IF cell N32:O32 > 0, rows 34 and 35 IF cell N34:O34 > 0, rows 36 and 37 IF cell N36:O36 > 0, rows 38 and 39 IF cell N38:O38 > 0, rows 40 and 41 IF cell N40:O40 > 0.

There is currently a formula in each of the selected cells that is why I was going for greater than zero.

View 1 Replies View Related

Vba To Unhide Rows, Print, And Rehide Rows

Feb 9, 2007

I am attempting unhide the same exact rows in multiple worksheets in Excel, Print the entire workbook, and then re-hide the same cells. As I am still learning VB i have been unsuccesfull. I have attached the code that I am using,

Sub Printdoc()
Dim sh As Worksheet

For Each sh In ThisWorkbook.Worksheets

With sh
Selection.EntireRow.Hidden = False
Selection.EntireRow.Hidden = True
End With

Next sh

End Sub

View 6 Replies View Related

Hide / Unhide Certain Rows

Apr 3, 2014

I highlighted a selection of rows and clicked HIDE, now I want to unhide certain rows and when I highlight the rows above and below and right click - unhide nothing happens. I need to Unhide to find something.

View 2 Replies View Related

Unhide Rows When Printing

Nov 28, 2007

Is there a VB routine that can unhide rows when I print?

View 9 Replies View Related

Unhide Hidden Rows..

Sep 5, 2009

I have a worksheet with a macro as follows: ...

View 6 Replies View Related

Macro To Unhide All Rows

Sep 16, 2009

Is there an easy way to make a macro to unhide all rows? I can do this to unhide a certain range however different rows maybe he hidden and so a set range won't work.

View 2 Replies View Related

Unhide One Row From Many Hidden Rows

Jun 7, 2007

I am trying to create a macro to unhide only a row at a time, from around 150 hidden rows altogether. It is basically to give the effect of adding extra rows to a "table" that a user could then input with new data (I have to do this way according to other set-up in the workbook), but this isn't very important to do with this question. When I do a Format<Row<Unhide from the Excel menu, it always unhides ALL of the hidden rows. I have fiddled around but can't seem to find a way to avoid this happening, all I want is for just one row to unhide. I thought it might depend what cell/s I had highlighted, but I haven't found a way that makes it work.

View 7 Replies View Related

Unhide Hidden Rows

Aug 21, 2007

I HID 4 rows using this help section. (Format - Hide)

Then, I modified several column widths simply by placing my curser at the top of the column and pulling it smaller or larger.
(I don't know if this did or did not cause my problem) which is simply that - I am now unable to find my hidden rows.

I know where they are supposed to be, but when I highlight them and click (Format - Unhide) nothing happens.

I tried (Find and Select - go to special) and no white bar shows up.

Can sombody please tell this frustrated Newby How to find the rows I just hid 1 hour ago?

If I posted in the wrong place, I appologise as I spent more time trying to figure out where and how to post than I did trying to solve my hidden row problem.

View 5 Replies View Related

Unhide Rows In 2007

Jun 17, 2008

I have done a search and drew a blank on this one. Hopefully there is an easy answer otherwise I see this as a fundamental flaw in Excel 2007 (on top of the lost productivity from ribbon interface). In all previous versions on Excel it was possible to select the rows either side of a hidden range (i.e. including the hidden rows) and right-click, Unhide. In Excel 2007 only visible cells are selected so this method does not work.

Hovering the mouse pointer on the row headings at the point of the hidden rows, waiting for the cursor to change and then right-click, Unhide only unhides the row imediately above, NOT the entire range. It seems the only way to unhide the entire range is to enter an address in the Name Box (taking care only hidden cells included otherwise only the visible ones will actually be selected) and then Format > Row > Unhide or Format > Row Height

View 6 Replies View Related

Hide / Unhide Section Of Rows

Apr 3, 2014

I have a button that I want to hide/unhide a section of rows.

This is the code a have so far:

[Code] .....

So I've named a a section of rows "rngHideRows". I've tried to use the command .Range("rngHideRows").EntireRow.Hidden = True (and viariants of this) but nothing I try works.

View 7 Replies View Related

VBA Hide / Unhide Rows On Other Sheet?

Jun 18, 2014


Private Sub Worksheet_Change(ByVal Target As Range)
With Sheets("Sheet2")
Select Case Target.Address(False, False)
Case "B12"[code].....

I need to change it so that it hides a range of rows, say (6:26) instead of adding a line of code for each of the rows from 6 to 26 that I want to hide

Also how can I go about hiding the same rows on 5 more sheets, can I add more sheetnames after "Sheet2"?

View 3 Replies View Related

Hide/unhide Rows With Zero Values

Jun 19, 2007

Need a macro which will hide rows having 0 values. On running once it will hide those rows having 0 values and on pressing second time it will unhide those hidden rows and so on.

View 14 Replies View Related

Hide Or Unhide Rows With Using Checkbox

Mar 7, 2009

I need to hide / unhide some rows in a sheet with the help of a activex checkbox... I want remove, let's say row 20:24 and row 34 with one checkbox.

View 6 Replies View Related

Hide, Unhide Rows And Count!?

Apr 2, 2009

I have a code that will hide all rows that have a "-" in Colum A, leaving me with the useful data.

However, this data is pulled from a front sheet that has data added to it.

What I would like my code to do is to relook at all the hidden cells, and if their value has changed from "-" to what ever the data may be then to unhide that row, displaying the data.

The code I'm using currently is: ....

View 10 Replies View Related

Hide/Unhide Rows From Name In List Box

Jan 11, 2010

I have a list box on a worksheet that contains the following names: field, vessel, pipe, structural. I would like to be able to unhide certain rows based
on the name shown in the list box. For example, if I choose field it would
unhide rows 3 thru 12, if i choose vessel it would unhide rows 13 thru 20, so on so forth. If nothing is choosen in the list box then rows stays hidden.

View 9 Replies View Related

Hide/unhide Rows Using Checkbox

Jan 20, 2010

i'm newbie here. i need to hide & unhide rows using checkbox in excel but i stuck. i write these simple code and it doesn't work at all. my bad..

View 2 Replies View Related

Unhide Rows In Multiple Sheets?

Oct 12, 2011

Is it possible to unhide a row in one sheet and the same line can be un hidden automatically ini 2 other sheets within the same workbook

View 1 Replies View Related

VBA - Hide / Unhide Multiple Rows

Oct 26, 2011

I have a workbook with multiple tabs. Each tab has about 600 rows. In each tab, I need to hide/unhide rows based on the value of a particular column in that row. For example,

Row1: 10,7.89,John,TRUE
Row2: 16,9.08,Ram,FALSE
Row3: 98,8.09,Joseph,FALSE
Row4: 76,1.23,Harry,TRUE

Using the 4th column (that has either TRUE or FALSE), I need to hide entire row. I am using a loop on the range and hiding each row. But it is taking about 4 minutes for each tab to loop through the 600 rows and hide/unhide the required rows. Is there a faster way to achieve this? Following is my code.

Sub Toggle_Rows()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Range("D1:D600")
If UCase(Cell.Value) = "TRUE" Then
Cell.EntireRow.Hidden = Not Cell.EntireRow.Hidden
End If
Application.ScreenUpdating = True
End Sub

View 1 Replies View Related

Hide / Unhide Rows With No Data

Sep 21, 2012

I think this is fairly straight forward but my limited VBA skills have me going round in circles. I would like to have a button that hides and unhides rows where Column L has blank values but only from row 80 to 200 only. I would also like the button text to change from "Hide rows" to "Unhide Rows".

From Row 80 to 100 hide rows where there is no value in column LButton should be clickable to hide rows and then clickable to unhidebutton text changes.

View 2 Replies View Related

Hide / Unhide Blank Rows With VBA

Nov 20, 2013

I am struggling to come up with a vba code that allows me to search column B, Rows 21:89 for blanks then hide/unhide the associated row. I would like it to be one macro so that I don't have to have two buttons on the sheet to hide/unhide.

View 5 Replies View Related

Toggle Hide/Unhide Rows

Jun 13, 2007

I have a macro that works fine with just numbers as a test run when I use it in the desired workbook/worksheets (where the values are returned via Indedx/match functions) there appears to be a small problem. (Below is the relevant post.)


Background is that I load raw data into a monthly account sheet which has the appropriate cost centre codes for allocating expenses.

I then use a vlookup in combination with indirect to place the summary data by costcentre code into annual worksheet.

I then have a summary sheet for printing purposes so I can print out a single month expenses by code to staple to the appropiate monthly costcentre statement. This is done by using Index & match functions looking at the annual summary sheet

What seems to be happening is that the code is sometimes recognizing formulas as a value & therefore showing zero values when I want only values 0 (as I sometimes have minus values).

Also sometimes when I go to unhide the all the rows it also is recognising some formulas as having value.

I am using Xl 2003.

View 9 Replies View Related

Auto Hide/Unhide Rows

Dec 15, 2008

I'm using this VBA code which is hiding cells in rows 59:111. Some of these cells have formulas and some don't.

Private Sub Hide_Unhide()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
For i = 59 To 111
Rows(i).Hidden = (Cells(i, "b").Value = 0) + (Cells(i, "b").Value = "")
Next i
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
Here is the problem I'm running into: I want this to run in the background so the user won't have to click anything to hide/unhide the cells whenever the options in the drop down list are changed and the data expands/collapses.

View 9 Replies View Related

Hide/unhide Rows With Buttons

Sep 14, 2009

I am using several toggle buttons to hide/show rows of data related to the specific toggle buttons. I also want to hide and show the toggle buttons as well. When I try to do that the data underneath the toggle buttons is hidden but the toggle buttons don't hide with the cells.

A solution for the problem that I am having would be to have the ability to click on a cell as if it were a toggle button and hide/show rows of data when clicked.


If there is a way to hide/show buttons as well would work too.

View 9 Replies View Related

Hide/Unhide Rows With Checkbox

Nov 11, 2009

I've had luck with hiding rows with a checkbox, but I cannot get them to unhide when I uncheck the box.

Here's my scenario - (using Excel 2000) In an estimating spreadsheet I have a print range of A1:N74. What I'd like to do is add a checkbox or button so I can hide and unhide rows based on a null or zero in column range b5:b62. This is for printing purposes, but I can't get a 'beforeprint' event to work either. All I need is box checked and cells hide, box unchecked and cells show (unhide).

Sub CheckBox1_Click()
Dim Rng As Range
Dim MyCell As Range
Set Rng = Range("B5:B62")
For Each MyCell In Rng
If MyCell.Value = "" Then
MyCell.EntireRow.Hidden = True
End If
Next MyCell
End Sub

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved