Lost all of my rows

[splacker]

I have a sheet with lots of calculations, macros, etc., but while setting up command buttons to hide and unhide rows, all the rows are hidden, and no matter what I try, I can't unhide them. I have a big gray screen with column headers and no row indicators. Please help me.

I have removed all of the vba from the file (It's copied elsewhere), so I need to do something from scratch to get back to my data.

 

[MrKowz]

Try this:

Press CTRL+A, then go to Format>Row>Unhide

 

[VoG]

Try running

Sub seerows()
Rows(1 & ":" & Rows.Count).Hidden = False
End Sub

 

[jim may]

In your spreadsheet (Not VBA) click on the Blank Rectangular object above Row1 and to the left of Column A - this selects all cells in the entire worksheet. from there Right-click on either Row or column Header - from Short-cut menu left-click UNHIDE!
Hope that helps,,,,,,,,,
Jim

 

[splacker]

Thanks to both of you. The CTRL-A / format worked. I thought I had tried it before, but obviously I had messed up.

I didn't need the vba tip, but I'll hang on to that information too.

Thanks again.