Macro stops working after rows/columns hidden call

**stefsj** · 03-17-2011, 02:31 PM

Hi,

I have been having issues with an old file of mine.

I have few different subs that have the rows().Hidden included in them. No matter what call I make, after the macro hides/unhides the rows it stops working and doesn't go to the next line of code. It could be as simple as this:

Please Login or Register  to view this content.

I have few other calls that do the same thing so it is not just this one subroutine.

I believe there must be some bugs in the file to do this. I am reworking this file now from scratch and sometimes notice the same thing, but if I save it and reopen it again it will work normally.

Any ideas why is this happening?

**MarvinP** · 03-17-2011, 04:22 PM

I wonder if you are trying to do something with the hidden row. If you hide a row and try to select a cell in that row, do you get the same error message?

Set a breakpoint in your code and step through it, while looking at the worksheet to see what is happening.

**stefsj** · 03-17-2011, 06:00 PM

Originally Posted by MarvinP

I wonder if you are trying to do something with the hidden row. If you hide a row and try to select a cell in that row, do you get the same error message?

Set a breakpoint in your code and step through it, while looking at the worksheet to see what is happening.

No unfortunately. I am not selecting anything from that row. And I know that it stops at there because I do the step-by-step process and it simply stops the macro after it hides the row. Doesn't even go to "End Sub"

**MarvinP** · 03-17-2011, 06:44 PM

I think the problem is in your SheetProtect routine.

What have you allowed the user to do. I'd bet you have protected the sheet to the point they can't select a cell you want them to select so you get an error message.

Read http://spreadsheets.about.com/od/exc...28_protect.htm which has all the options you can protect.

**stefsj** · 03-17-2011, 07:44 PM

Well,

If that's true it should work when the sheet is unprotected, but it doesn't. This is a simple code that works on any other file, but in this particular file it crashes at that row and it is a mystery for me.

**MarvinP** · 03-17-2011, 07:52 PM

My father in law used to use this line on me frequently. Things would crash and he would say "I didn't change anything" or "It worked on all other sheets that are exactly the same".

If it crashes on this and not on others, you job is to find what is different between THIS one and all the others.

It all comes down to some assumpion you have that is false. You assume the only difference is unprotected or protected. Perhaps it is something else!? It will continue to be a mystery until you find which assumption you have that is not exactly correct.

I couldn't run you code as you had a call to SheetProtect that you didn't supply. Your code ran find on my machine when I commented out the call.