All I can do is put this intot the Worksheet_Activate Event:

Private Sub Worksheet_Activate()
Cells.Select
Selection.EntireRow.Hidden = False
Selection.EntireColumn.Hidden = False
End Sub

EM

"ExcelMonkey" wrote:

So Tom, I just went through and redefined every custom view I have making
sure that the sheet in question had all its rows/columns unhidden while I was
redefining the views. I then saved the file. Now when I chose any of my
redefined custom views, and go back to the sheet in question, everything is
hidden. What a joke. I can't believe this. This completely renders the
spreadsheet useless as users will not know what is going on. I need the
views too.

I can always try to replace the views with print macros - but I shouldn't
need to do this.

EM

"Tom Ogilvy" wrote:

A custom view has a workbook perspective as I recall - not just for the sheet
that was active when it was applied. So you probably do have to redefine
your views.

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote:


This seems to have after I pull up custom views on other sheets. Could it be
that I have to uhide the rows/columns and then reset every custom view and
then save?

EM

"ExcelMonkey" wrote:

I have a model which is getting quite large. At one point I was manually (no
VBA code) hiding rows and columns of a particular sheet for esthetics.
However when I open the model, everything in this particular sheet is now
hidden. So I highlight everything and unhide and save. But I have to do
this every do often. Its almost as though Excel is keeping something in
residual memory which is causing the the sheet to hide everything in this
sheet every so often. Unhiding and saving only seems to work for a while.
The next day I come in, open up and all is hidden again. Can anybody tell
why this his happening? The only fix I can think of is to have a routine
which unhides everything in the sheet upon the open event. But this is silly.

Thanks

EM