"alt + enter" closes the worksheet
 

I opened a workbook and pressed "alt+enter" straight away, the result was the
workbook gets closed.
Is this an excel "feature"?
I have searched for the "alt+enter" combination, but all the results point
to inserting a line break in a cell.
Anyone, any ideas, please?

"alt + enter" closes the worksheet
 

Just tinkered here in xl03

Seems like your
.. pressed "alt+enter" straight away ..
opens a new book. But it doesn't close your book (just gets "hidden"). You
can see/go to your other book via clicking Window choose the book from
dropdown

In Edit mode, when you double-click into a cell to type something,
then pressing alt+enter will break for a new line
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jarr" wrote:
I opened a workbook and pressed "alt+enter" straight away, the result was the
workbook gets closed.
Is this an excel "feature"?
I have searched for the "alt+enter" combination, but all the results point
to inserting a line break in a cell.
Anyone, any ideas, please?

"alt + enter" closes the worksheet
 

Max
Thanks for the note.
That was my first thought.
I have opened two workbooks, press "alt+enter" (without selecting any cells)
and the workbook closes (does not ask for "Save").
I then, click on "window" menu , and use the drop down to select the
workbook but it is not there.
I even tried "window" -- "Arrange" but the same end result: The workbook
is not "hidden".
By the way, I know about "alt+enter" for adding break lines.
Any other thoughts...

Jarr

"Max" wrote:

Just tinkered here in xl03

Seems like your
.. pressed "alt+enter" straight away ..
opens a new book. But it doesn't close your book (just gets "hidden"). You
can see/go to your other book via clicking Window choose the book from
dropdown

In Edit mode, when you double-click into a cell to type something,
then pressing alt+enter will break for a new line
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jarr" wrote:
I opened a workbook and pressed "alt+enter" straight away, the result was the
workbook gets closed.
Is this an excel "feature"?
I have searched for the "alt+enter" combination, but all the results point
to inserting a line break in a cell.
Anyone, any ideas, please?

"alt + enter" closes the worksheet
 

Any other thoughts...
I'm out. Maybe others could offer
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jarr" wrote in message
...
Max
Thanks for the note.
That was my first thought.
I have opened two workbooks, press "alt+enter" (without selecting any
cells)
and the workbook closes (does not ask for "Save").
I then, click on "window" menu , and use the drop down to select the
workbook but it is not there.
I even tried "window" -- "Arrange" but the same end result: The workbook
is not "hidden".
By the way, I know about "alt+enter" for adding break lines.
Any other thoughts...

Jarr

"alt + enter" closes the worksheet
 

Max
Can you duplicate the issue?

"Max" wrote:

Any other thoughts...
I'm out. Maybe others could offer
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jarr" wrote in message
...
Max
Thanks for the note.
That was my first thought.
I have opened two workbooks, press "alt+enter" (without selecting any
cells)
and the workbook closes (does not ask for "Save").
I then, click on "window" menu , and use the drop down to select the
workbook but it is not there.
I even tried "window" -- "Arrange" but the same end result: The workbook
is not "hidden".
By the way, I know about "alt+enter" for adding break lines.
Any other thoughts...

Jarr

"alt + enter" closes the worksheet
 

Can you duplicate the issue?
No. It opens a new book, as mentioned in my 1st response. When a book is
opened, there would already be a cell selected. Pressing alt+enter simply
opens a new book for me.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"alt + enter" closes the worksheet
 

If you open excel in safe mode:

Close excel
windows start button|Run
type:
excel /safe

do you get the same results when you hit alt-enter?

If you don't, then you might have a macro that's intercepting the alt-enter and
doing what it wants to do. (Starting in safe mode will avoid this macro.)

If the problem goes away, are you ready to do some detective work to find out
the culprit?

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Essentially, you'll turn off all the addins/startup workbooks and then open
excel. And then turn on each addin (closing and reopening) one at a time to
find the culprit.

Jarr wrote:

I opened a workbook and pressed "alt+enter" straight away, the result was the
workbook gets closed.
Is this an excel "feature"?
I have searched for the "alt+enter" combination, but all the results point
to inserting a line break in a cell.
Anyone, any ideas, please?

--

Dave Peterson

"alt + enter" closes the worksheet
 

On my Excel 2003 open a workbook, make no changes then hit Alt + Enter in
non-edit mode closes the workbook with no save or message.

Opened VBE and no project shows up so book is not just hidden.

Most strange


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 14:47:05 +0800, "Max" wrote:

Can you duplicate the issue?
No. It opens a new book, as mentioned in my 1st response. When a book is
opened, there would already be a cell selected. Pressing alt+enter simply
opens a new book for me.

"alt + enter" closes the worksheet
 

Dave
Thanks for your input. I have learned about Excel /safe (I am assuming it
works with all MS apps).
I did as you suggested, and I could repeat the issue. I open a workbook,
did not click on anything, press "alt+enter" and workbook is closed without
prompts..



"Dave Peterson" wrote:

If you open excel in safe mode:

Close excel
windows start button|Run
type:
excel /safe

do you get the same results when you hit alt-enter?

If you don't, then you might have a macro that's intercepting the alt-enter and
doing what it wants to do. (Starting in safe mode will avoid this macro.)

If the problem goes away, are you ready to do some detective work to find out
the culprit?

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Essentially, you'll turn off all the addins/startup workbooks and then open
excel. And then turn on each addin (closing and reopening) one at a time to
find the culprit.

Jarr wrote:

I opened a workbook and pressed "alt+enter" straight away, the result was the
workbook gets closed.
Is this an excel "feature"?
I have searched for the "alt+enter" combination, but all the results point
to inserting a line break in a cell.
Anyone, any ideas, please?

--

Dave Peterson

"alt + enter" closes the worksheet
 

Gord,
Bizarre! Just tried it out on my home pc. Earlier attempts were on a laptop.
Pressing alt+enter opens a new book, as before. Consistent behaviour for me
it seems <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
On my Excel 2003 open a workbook, make no changes then hit Alt + Enter in
non-edit mode closes the workbook with no save or message.

Opened VBE and no project shows up so book is not just hidden.

Most strange