What does CTRL-ALT-SHIFT-F4 do?

  • Thread starter Thread starter R Avery
  • Start date Start date
R

R Avery

I know that Alt-F4 closes a program.
But when I tried CTRL-ALT-SHIFT-F4, the following msgbox popped up:

"Cannot open Microsoft Excel Add-In for editing. Please edit the source
document instead."

I tried to replicate what happened, and failed until I did the
following. First, have an unsaved workbook open. Then, press the
shortcut key. When the dialog prompts you to save, cancel. Then, press
the shortcut key again, and I get the above msgbox every time. What is
it doing?


Also, CTRL-SHIFT-F4 seems to activate the previous blank cell either
within a selection, or for the entire sheet if only a single cell is
selected. Can someone confirm that this is indeed what is going on?
 
I tried to replicate what happened, and failed until I did the
following. First, have an unsaved workbook open. Then, press the
shortcut key. When the dialog prompts you to save, cancel. Then, press
the shortcut key again, and I get the above msgbox every time. What is
it doing?
Click to expand...

I forgot to clarify that after the msgbox pops up, Excel closes without
prompting to save any unsaved workbooks.
 
ShutDOWN- correctly stops all running applications, unloads them from
memory, shuts the sytem down and powers off the PC
Keyboard shortcut: CTRL-ALT-SHIFT-F4
 
Shift-F4 does seem to select the next empty cell within the selection or the
used range if only one cell is selected. I never noticed that. Very
interestng! Ctrl-Shift-F4 goes in reverse.

For the other thing what add-ins do you have open? (Tools, Addins). It
seems that the Alt-F4 part of your keystroke is closing an add-in (since
Excel thinks it's quitting) and then the add-in is being re-opened somehow.
But with Shift down Excel thinks you're trying to open the add-in for
editing (this is how it was done under Excel 4) and that warning is left
over from that time.
 
Shift-F4 does seem to select the next empty cell within the selection orused range if only one cell is selected. I never noticed that. Very
interesting! Ctrl-Shift-F4 goes in reverse.

Not quite so interesting, in the light of the day. Shift-F4 does a Find,
Next. If you haven't done a Find yet the Find What is nothing/empty.


--
Jim Rech
Excel MVP
| Shift-F4 does seem to select the next empty cell within the selection or
the
| used range if only one cell is selected. I never noticed that. Very
| interestng! Ctrl-Shift-F4 goes in reverse.
|
| For the other thing what add-ins do you have open? (Tools, Addins). It
| seems that the Alt-F4 part of your keystroke is closing an add-in (since
| Excel thinks it's quitting) and then the add-in is being re-opened
somehow.
| But with Shift down Excel thinks you're trying to open the add-in for
| editing (this is how it was done under Excel 4) and that warning is left
| over from that time.
|
| --
| Jim Rech
| Excel MVP
| | >I know that Alt-F4 closes a program.
| > But when I tried CTRL-ALT-SHIFT-F4, the following msgbox popped up:
| >
| > "Cannot open Microsoft Excel Add-In for editing. Please edit the source
| > document instead."
| >
| > I tried to replicate what happened, and failed until I did the
following.
| > First, have an unsaved workbook open. Then, press the shortcut key.
When
| > the dialog prompts you to save, cancel. Then, press the shortcut key
| > again, and I get the above msgbox every time. What is it doing?
| >
| >
| > Also, CTRL-SHIFT-F4 seems to activate the previous blank cell either
| > within a selection, or for the entire sheet if only a single cell is
| > selected. Can someone confirm that this is indeed what is going on?
|
|
 
For the other thing what add-ins do you have open? (Tools, Addins). It
seems that the Alt-F4 part of your keystroke is closing an add-in (since
Excel thinks it's quitting) and then the add-in is being re-opened somehow.
But with Shift down Excel thinks you're trying to open the add-in for
editing (this is how it was done under Excel 4) and that warning is left
over from that time.
Click to expand...

The other add-ins that I have open are my own personal add-ins. But why
do I have to cancel the save operation of the currently open unsaved
document and then press the keyboard shortcut again to get the prompt
about the Add-in? And why does it then quit Excel without saving or
prompting to save any open documents?
 
ShutDOWN- correctly stops all running applications, unloads them from
memory, shuts the sytem down and powers off the PC
Keyboard shortcut: CTRL-ALT-SHIFT-F4
Click to expand...

That keyboard shortcut does not do the above action for me, either in
Excel or when no applications are at the front. But, where did you find
that anyway? Do you have a list of keyboard shortcuts?
 
Back
Top