Shortcut Key Creation
 

Shortcut Key Creation
Can I create a shortcut key for save and close in Excel?
Thaks

Shortcut Key Creation
 

This is code that will do it, so record a new macro, give it a shortcut
key, then stop the recorder. Edit that macro and paste in this code:


ThisWorkbook.Save
Application.Quit


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62807

Shortcut Key Creation
 

You have snipped all of OP's post but I believe he just wanted to save and
close the workbook, not Close Excel.

Always best when responding to leave some of the original posting so's other
can see to what you are referring.


Gord Dibben MS Excel MVP

On Thu, 12 Feb 2009 01:35:52 +0000, JBeaucaire
wrote:


This is code that will do it, so record a new macro, give it a shortcut
key, then stop the recorder. Edit that macro and paste in this code:


ThisWorkbook.Save
Application.Quit

Shortcut Key Creation
 

Actually, I stopped using the Microsoft interface, notifications stopped
working for me several days ago and it's just behaving oddly.

I've also noticed triple, quadruple posting on the site, the same thing
even happened to several of my replies.

So I'm on the CodeCage reading these messages and just used a "reply"
instead of Quote, my bad. I'll try to remember to use the QUOTE button
instead.

Anyone else seeing that craziness on the microsoft community for
Excel?

Gord Dibben;226397 Wrote:
You have snipped all of OP's post but I believe he just wanted to save
and
close the workbook, not Close Excel.

Always best when responding to leave some of the original posting so's
other
can see to what you are referring.


Gord Dibben MS Excel MVP

On Thu, 12 Feb 2009 01:35:52 +0000, JBeaucaire
wrote:


This is code that will do it, so record a new macro, give it a
shortcut
key, then stop the recorder. Edit that macro and paste in this code:


ThisWorkbook.Save
Application.Quit


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62807

Shortcut Key Creation
 

Yes.

Posting from the MS discussion groups CDO Interface has been throwing a
"message not sent" error and posters just keep trying.

Some have posted 4 or 5 times in several newsgroiups hoping to get something
through.

All are being posted but posters don't know that.


Gord

On Thu, 12 Feb 2009 04:25:05 +0000, JBeaucaire
wrote:


Actually, I stopped using the Microsoft interface, notifications stopped
working for me several days ago and it's just behaving oddly.

I've also noticed triple, quadruple posting on the site, the same thing
even happened to several of my replies.

So I'm on the CodeCage reading these messages and just used a "reply"
instead of Quote, my bad. I'll try to remember to use the QUOTE button
instead.

Anyone else seeing that craziness on the microsoft community for
Excel?

Gord Dibben;226397 Wrote:
You have snipped all of OP's post but I believe he just wanted to save
and
close the workbook, not Close Excel.

Always best when responding to leave some of the original posting so's
other
can see to what you are referring.


Gord Dibben MS Excel MVP

On Thu, 12 Feb 2009 01:35:52 +0000, JBeaucaire
wrote:


This is code that will do it, so record a new macro, give it a
shortcut
key, then stop the recorder. Edit that macro and paste in this code:


ThisWorkbook.Save
Application.Quit