I created a small database using Excel, this file has been running for
serveral months now without a problem. Today, I went to enter in information
and in the middle of entering the information the sheets, tabs and grid lines
disappeared. I've never experienced this until now. I tried to retrieve the
information but it is not letting me, however, all my VB Code is still there.
What can I do? if you need more explaination let me know.

Check the worksheet menu Options - view. these ae the items that are
selected on my PC.

Startup Task Pane
Formula Bar
Status Bar
Window in Task bar
Comment Indicator only
Show All
Grid Lines
Row and Column Headers
Outline Symbols
Zero Values
Horizontal Scroll
Vertical Scroll Bar
Sheet Tabs

"Richard" wrote:

I created a small database using Excel, this file has been running for
serveral months now without a problem. Today, I went to enter in information
and in the middle of entering the information the sheets, tabs and grid lines
disappeared. I've never experienced this until now. I tried to retrieve the
information but it is not letting me, however, all my VB Code is still there.
What can I do? if you need more explaination let me know.

Thanks Joel, but this was not the problem. What the problem is, I open the
file and I get a grey screen with no sheets, tabs or grid lines. I checked
the VB editor and I noticed that ALL my VB codes are there and shows each
sheet, however, when I check the properties for each sheet it is telling me
that the sheet is -1 - xlSheetVisible and it doesn't give me the option to
view Object because the sheet is not being displayed properly. Any help would
be much appreciated.

"Joel" wrote:

Check the worksheet menu Options - view. these ae the items that are
selected on my PC.

Startup Task Pane
Formula Bar
Status Bar
Window in Task bar
Comment Indicator only
Show All
Grid Lines
Row and Column Headers
Outline Symbols
Zero Values
Horizontal Scroll
Vertical Scroll Bar
Sheet Tabs

"Richard" wrote:

I created a small database using Excel, this file has been running for
serveral months now without a problem. Today, I went to enter in information
and in the middle of entering the information the sheets, tabs and grid lines
disappeared. I've never experienced this until now. I tried to retrieve the
information but it is not letting me, however, all my VB Code is still there.
What can I do? if you need more explaination let me know.

You may have all the worksheets hidden. Try unhide worksheet

2003 menu
Windows

2007
Home - Format - Cells

"Richard" wrote:

Thanks Joel, but this was not the problem. What the problem is, I open the
file and I get a grey screen with no sheets, tabs or grid lines. I checked
the VB editor and I noticed that ALL my VB codes are there and shows each
sheet, however, when I check the properties for each sheet it is telling me
that the sheet is -1 - xlSheetVisible and it doesn't give me the option to
view Object because the sheet is not being displayed properly. Any help would
be much appreciated.

"Joel" wrote:

Check the worksheet menu Options - view. these ae the items that are
selected on my PC.

Startup Task Pane
Formula Bar
Status Bar
Window in Task bar
Comment Indicator only
Show All
Grid Lines
Row and Column Headers
Outline Symbols
Zero Values
Horizontal Scroll
Vertical Scroll Bar
Sheet Tabs

"Richard" wrote:

I created a small database using Excel, this file has been running for
serveral months now without a problem. Today, I went to enter in information
and in the middle of entering the information the sheets, tabs and grid lines
disappeared. I've never experienced this until now. I tried to retrieve the
information but it is not letting me, however, all my VB Code is still there.
What can I do? if you need more explaination let me know.

Thanks Joel, I got my information restored. I still don't know what happened
but whatever.... What I did to retrieve the information was open up another
excel file and Import from External Data. Then copy and paste the
information in my backup file.

Thanks for the help..

Good-day

"Joel" wrote:

You may have all the worksheets hidden. Try unhide worksheet

2003 menu
Windows

2007
Home - Format - Cells

"Richard" wrote:

Thanks Joel, but this was not the problem. What the problem is, I open the
file and I get a grey screen with no sheets, tabs or grid lines. I checked
the VB editor and I noticed that ALL my VB codes are there and shows each
sheet, however, when I check the properties for each sheet it is telling me
that the sheet is -1 - xlSheetVisible and it doesn't give me the option to
view Object because the sheet is not being displayed properly. Any help would
be much appreciated.

"Joel" wrote:

Check the worksheet menu Options - view. these ae the items that are
selected on my PC.

Startup Task Pane
Formula Bar
Status Bar
Window in Task bar
Comment Indicator only
Show All
Grid Lines
Row and Column Headers
Outline Symbols
Zero Values
Horizontal Scroll
Vertical Scroll Bar
Sheet Tabs

"Richard" wrote:

I created a small database using Excel, this file has been running for
serveral months now without a problem. Today, I went to enter in information
and in the middle of entering the information the sheets, tabs and grid lines
disappeared. I've never experienced this until now. I tried to retrieve the
information but it is not letting me, however, all my VB Code is still there.
What can I do? if you need more explaination let me know.