How do I fix a workbook.
 

I have a workbook with 5 sheets and macros with forms. When I select any one
of the worksheets by the tab with the mouse, the cursor goes to a page and
the only way I can get Excel to stop is to cancel the task.

How do I either fix this workbook or copy all the sheets to another
workbook? TIA
--
Bill

What version of Excel, Bill? Have you tried File--Open and choose the
Repair option?
************
Anne Troy
www.OfficeArticles.com

"bill" wrote in message
...
I have a workbook with 5 sheets and macros with forms. When I select any
one
of the worksheets by the tab with the mouse, the cursor goes to a page and
the only way I can get Excel to stop is to cancel the task.

How do I either fix this workbook or copy all the sheets to another
workbook? TIA
--
Bill

Anne,

I don't have that option on the file open menu. I have Excel 2002 SP3.
--
Bill


"Anne Troy" wrote:

What version of Excel, Bill? Have you tried File--Open and choose the
Repair option?
************
Anne Troy
www.OfficeArticles.com

"bill" wrote in message
...
I have a workbook with 5 sheets and macros with forms. When I select any
one
of the worksheets by the tab with the mouse, the cursor goes to a page and
the only way I can get Excel to stop is to cancel the task.

How do I either fix this workbook or copy all the sheets to another
workbook? TIA
--
Bill

Bill,

I think Anne meant, do File, Open, and then (before anything else) try
the Repair option
Try the Help column for the Repair (Detect and Repair) option.



bill Wrote:
Anne,

I don't have that option on the file open menu. I have Excel 2002
SP3.
--
Bill


"Anne Troy" wrote:

What version of Excel, Bill? Have you tried File--Open and choose
the
Repair option?
************
Anne Troy
www.OfficeArticles.com

"bill" wrote in message
...
I have a workbook with 5 sheets and macros with forms. When I
select any
one
of the worksheets by the tab with the mouse, the cursor goes to a
page and
the only way I can get Excel to stop is to cancel the task.

How do I either fix this workbook or copy all the sheets to
another
workbook? TIA
--
Bill





--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395513

I think you do have that option.

File|Open|select your file
But instead of clicking on the Open button, click on that down arrow on that
open button. You'll see an "open and repair" option in that popup.

bill wrote:

Anne,

I don't have that option on the file open menu. I have Excel 2002 SP3.
--
Bill

"Anne Troy" wrote:

What version of Excel, Bill? Have you tried File--Open and choose the
Repair option?
************
Anne Troy
www.OfficeArticles.com

"bill" wrote in message
...
I have a workbook with 5 sheets and macros with forms. When I select any
one
of the worksheets by the tab with the mouse, the cursor goes to a page and
the only way I can get Excel to stop is to cancel the task.

How do I either fix this workbook or copy all the sheets to another
workbook? TIA
--
Bill




--

Dave Peterson

I think I'd open excel in safe mode and try it.

close excel
windows start button|run
excel /safe
file|open your workbook

If the problem doesn't occur, maybe it's a macro that's misbehaving.

If it does happen, I don't have another guess.

bill wrote:

I have a workbook with 5 sheets and macros with forms. When I select any one
of the worksheets by the tab with the mouse, the cursor goes to a page and
the only way I can get Excel to stop is to cancel the task.

How do I either fix this workbook or copy all the sheets to another
workbook? TIA
--
Bill

--

Dave Peterson

Dave,

Your explanation was the best. I did fix the file. Thanks.
--
Bill


"Dave Peterson" wrote:

I think you do have that option.

File|Open|select your file
But instead of clicking on the Open button, click on that down arrow on that
open button. You'll see an "open and repair" option in that popup.

bill wrote:

Anne,

I don't have that option on the file open menu. I have Excel 2002 SP3.
--
Bill

"Anne Troy" wrote:

What version of Excel, Bill? Have you tried File--Open and choose the
Repair option?
************
Anne Troy
www.OfficeArticles.com

"bill" wrote in message
...
I have a workbook with 5 sheets and macros with forms. When I select any
one
of the worksheets by the tab with the mouse, the cursor goes to a page and
the only way I can get Excel to stop is to cancel the task.

How do I either fix this workbook or copy all the sheets to another
workbook? TIA
--
Bill




--

Dave Peterson