Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Model opens up with hidden rows and columns
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Model opens up with hidden rows and columns
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Model opens up with hidden rows and columns
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Model opens up with hidden rows and columns
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Model opens up with hidden rows and columns
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Model opens up with hidden rows and columns
Make a copy of your workbook
open the copy delete all custom views. Now make sure all the rows are unhidden. Save the workbook. close it. Open it. If the rows are unhidden, then recreate your custom views making sure you never hide the rows. Create them one at a time, saving and closing after creating. When you open, make sure you haven't recreated the problem. -- Regards, Tom Ogilvy "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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Model opens up with hidden rows and columns
So, I delted all the views. I then created them from scratch. When you
create the view it provides two check boxes. One for Print Settings and the other for Hidden Rows/Columns. I uncheck the hidden rows/columns. I did this for all the views. This seemed to make a difference. Not sure why as I am assuming the check box is supposed to refer to the sheet the view is on. Whereas my problem was that if I chose a certain view it then hid rows on a different sheet altogether. So now I write a macro which chooses the viewsa and then prints them. For example: ActiveWorkbook.CustomViews("Legend&Dates&Finance&I ndexation").Show ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True However I am noticing that certain vews are not printing up the way they are supposed to. I have noticed that I have to actually select the view twice to make look the way its supposed to. As such, I have write the code like this to duplicate the selection actions: ActiveWorkbook.CustomViews("Legend&Dates&Finance&I ndexation").Show ActiveWorkbook.CustomViews("Legend&Dates&Finance&I ndexation").Show ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True I think this is bizarre. Also I am not convinced yet that even if I fix this that it will work consistently on another computer/printer. EM "Tom Ogilvy" wrote: Make a copy of your workbook open the copy delete all custom views. Now make sure all the rows are unhidden. Save the workbook. close it. Open it. If the rows are unhidden, then recreate your custom views making sure you never hide the rows. Create them one at a time, saving and closing after creating. When you open, make sure you haven't recreated the problem. -- Regards, Tom Ogilvy "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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Model opens up with hidden rows and columns
This does not work either. I unhide, pick a customer view, then go back to
the sheet, as expected, everything is hidden again, I unhide, redefine the print view and save. But it eventualy hides it again. Wondering if I need to reset all customer views from scratch. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing hidden rows or columns | Excel Discussion (Misc queries) | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Protect Hidden Columns and Rows | Excel Discussion (Misc queries) | |||
hidden rows/columns | Excel Discussion (Misc queries) |