A collegue of mine have a grey background in excel when opening the page. However, when I look at print preview I can see the data.
Can someone please enlighten me, how can I make this spreadsheet visiable again.
Thanks
A collegue of mine have a grey background in excel when opening the page. However, when I look at print preview I can see the data.
Can someone please enlighten me, how can I make this spreadsheet visiable again.
Thanks
Right Click on the Sheet Tab name (at the bottom). Click on the View Code icon. Enter this code into the module that appears.
Sub Macro1()
'Unhide Rows
ActiveCell.Rows("1:65536").EntireRow.Select
Selection.EntireRow.Hidden = False
End Sub
Next, press Alt+F8 and choose to run Macro 3. It should unhide all rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks