Problems with Rows being hidden

[SusanK]

How can I stop rows from being hidden at the side of a spreadsheet. Each time I open the Spread, a lot of the rows are hidden and I have to spend time making them viewable again. Even after saving the spreadsheet in its current state, next time when opened they have reverted back to being hidden. Any help would be great.
Thanks

 

[jimboy]

Save this in a module at it will unhide the rows on open;

Sub auto_open()
    Rows("1:65536").Hidden = False
End Sub

 

[Cbrine]

I can't explain why your rows keep coming up hidden, but I can give you a shortcut to unhide them. It sounds like you are unhiding one at a time.

Just click on the top left corner of the sheet to highlight the entire sheet. Then right click on the actual sheet, doesn't matter where as long as it the spreadsheet portion. Select unhide from the menu. This will unhide ALL hidden rows on the spreadsheet.

Hope this helps.

 

[jimboy]

I can't explain why your rows keep coming up hidden

I assumed you were working on a shared workbook.

Your not pressing control 9 are you (the shortcut for hide row) instead of shift 9?

 

[SusanK]

Yes I am working on a Shared Workbook and No not pressing anything. The worksheet is opening with the rows hidden and when i 'unhide ' them all and make changes and resave, once closed and re-opened its back to the hidden rows again

 

[north19701]

It may have something to do with the Shared workbook settings. go to Tools - Share Workbook go to the Advanced Tab and see if Include in personal views Print Settings and Filter Settings are checked.