View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default What does CTRL-ALT-SHIFT-F4 do?

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
"R Avery" wrote in message
...
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?