Can't Unhide columns - What the ???

[TAPS_MikeDion]

Hi all,
Has anyone ever run into this? I was working with Excel 2007 at home and hid all columns to the right of the last column in every sheet. Now that I'm at work using Excel 2003, the last visible column in each sheet has no border lines for each cell, which for whatever reason Excel won't allow me to change, and I cannot Unhide the hidden columns!

ANY help would be greatly appreciated.

Thanks,
Mike

 

[Tom Urtis]

Check if you have Freeze Panes enabled, and unfreeze it.

There is a ghost of a chance that it might be that the column width is 0.17 which makes the column look hidden when really it is visible and narrow. Try autofitting all columns or setting the column width for all columns to 10 if freeze panes is not the answer.

 

[TAPS_MikeDion]

Hi Tom,
Thanks for trying, but Freeze Panes was not checked and the column width idea didn't work either.

-Mike

 

[Tom Urtis]

See if the panes are split or the scroll area is limited.

Activate the worksheet where this is happening.

From your worksheet press Alt+F11 (careful, that's ALT + F11).
Then press Ctrl+G

Paste or type in
ActiveWindow.SplitColumn = 0: cells.Columns.hidden = false: ActiveSheet.ScrollArea = ""
and hit the enter key.

Press Alt+Q and see if that fixed what's ailing the sheet.

 

[TAPS_MikeDion]

I'll try that when I get to work tonight, thanks.

Funny thing though, I worked on it at work and saved it with 2003, and then got home and opened it with 2007 and everything is fine. I'm wondering if it's an 03/07 glitch.

 

[iamskippy]

Check if you have Freeze Panes enabled, and unfreeze it.

There is a ghost of a chance that it might be that the column width is 0.17 which makes the column look hidden when really it is visible and narrow. Try autofitting all columns or setting the column width for all columns to 10 if freeze panes is not the answer.

TY

 

[DaveU]

Hi Tom,

Sorry, I realize this is an old post, but, I just ran into exactly the same problem as Mike, the only difference is I'm using a 2003/2010 Excel combo. Has this been resolved, as I didn't see any feedback from Mike?

Regards,

Dave

 

[Tom Urtis]

Hmmmm...More often than not, an absence of followup means the original poster has found the solution. People tend more to write when they have a problem than when they have a fix. So I assume this has been resolved, especially after another poster came forward with a Thank You. In your case, I wonder what a 2003/2010 Excel combo is, and if you have tried all the possible approaches for a fix that were suggested in this thread. Please post back with what you are seeing exactly, and what you have tried, and we can take it from there.

 

[DaveU]

Hi Tom,

Thanks for your reply.

So I assume this has been resolved, especially after another poster came forward with a Thank You.

Oh, that explains "TY"!

I have a workbook that runs a macro to hide/unhide selected columns, then saves & closes the workbook. This works well in 2010, yet if I open the same workbook with 2003, the columns will not unhide, programatically or manually. I can increase the width (which was 0), and make them visible that way, which suggests that 2003 isn't recognizing that the columns are hidden. And yet when I switch back to 2010, everything works fine.

And I have ruled out split window/scroll area as suggested in this thread. I'll do some more experimenting, and let you know if I come up with anything.

regards,

Dave

 

[Michael M]

Dave
It may also be the code itself, and it's compatiblity with 03/10...just a thought !