I can open the excel file but the worksheet is gone!

[omdiarmat]

hello every one.
i was working with an excel file and inserting data into it. by accident i think i hit a shortcut button combination and the worksheet is now gone! the file still exists and it has 35 kb of information in it but when i open the file, the worksheet is not there. i think that shortcut has closed or hidden the worksheet or something like that. i created the file just now so i have no backup.
any solutions to this problem?!

 

[Comfy]

Within Excel Press Alt + F11

This should open the "Microsoft Visual Basic for Applications" window

In the toolbar select "View" and Choose "Project Explorer" from the list.
In the toolbar select "View" and Choose "Properties Window" from the list.

Within the "Project Explorer" window you should see "VBAProject (Your workbook name)"

Expand this if it isn't already and look for a folder item called, "Microsoft Excel Object"

Look for the worksheet name in this folder and select it.

Now look in the "Properties Window" for Visible

Change this from xlSheetHidden or xlSheetVeryHidden to xlSheetVisible

 

[Trevor G]

Welcome to the Forum, place your mouse on a Tab (bottom of worksheets) and use the right mouse button and see if you can unhide.

 

[omdiarmat]

Within Excel Press Alt + F11

This should open the "Microsoft Visual Basic for Applications" window

In the toolbar select "View" and Choose "Project Explorer" from the list.
In the toolbar select "View" and Choose "Properties Window" from the list.

Within the "Project Explorer" window you should see "VBAProject (Your workbook name)"

Expand this if it isn't already and look for a folder item called, "Microsoft Excel Object"

Look for the worksheet name in this folder and select it.

Now look in the "Properties Window" for Visible

Change this from xlSheetHidden or xlSheetVeryHidden to xlSheetVisible

well, thanks for your reply, but all of the sheets are xlSheetVisible! what can i do now?

 

[MARK858]

Seeing you can see the Vb editor does running the code line below make any difference

Sub Macro5()
    ActiveWindow.WindowState = xlMaximized
End Sub

 

[omdiarmat]

Thanks for your help, i've tried every thing but, it seems that it is gone for good! i think i'll have to go over the whole designing process again. next time i'll be more careful with the **** keyboard shortcuts!
thanks again every one

 

[MARK858]

Sorry, I missed your reply, if the sheet appears in the VB editor it is still there we just need to work out what you have done.

Try going to the view tab and click Arrange All and check the Horizontal checkbox, can you see the problem sheet amongst them?