I have an important file that in times past I've been able to hide and
unhide rows and columns as needed. Now, a number of worksheets will
suddenly no longer unhide. Is there a way to force hidden columns to
be unhidden, but will not prevent them from being hidden later?
Thanks for any help.

Michael

If you hid them using a macro with xlveryhidden they can only be unhidden by
code.
Else, goto the cells cell(above the 1 and to the left of the A
titles)>format>rows>unhide
OR, row height??? set to 0
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
<(E-Mail Removed)> wrote in message
news:829bf3a0-682a-4c6e-bece-(E-Mail Removed)...
>I have an important file that in times past I've been able to hide and
> unhide rows and columns as needed. Now, a number of worksheets will
> suddenly no longer unhide. Is there a way to force hidden columns to
> be unhidden, but will not prevent them from being hidden later?
> Thanks for any help.
>
> Michael

Maybe you unhide them, but have the windows frozen so you can't scroll to see
them.

In xl2003 menus, I'd use:
window|unfreeze panes
then scroll up/to the left

(after you've unhidden the rows/columns)

(E-Mail Removed) wrote:
>
> I have an important file that in times past I've been able to hide and
> unhide rows and columns as needed. Now, a number of worksheets will
> suddenly no longer unhide. Is there a way to force hidden columns to
> be unhidden, but will not prevent them from being hidden later?
> Thanks for any help.
>
> Michael

--

Dave Peterson

If say column D is hidden because it has been made to zero width, use Go to
and go to D1. You can then resize.
Gus

<(E-Mail Removed)> wrote in message
news:829bf3a0-682a-4c6e-bece-(E-Mail Removed)...
>I have an important file that in times past I've been able to hide and
> unhide rows and columns as needed. Now, a number of worksheets will
> suddenly no longer unhide. Is there a way to force hidden columns to
> be unhidden, but will not prevent them from being hidden later?
> Thanks for any help.
>
> Michael