Shortcut Key Creation

V

vlhogg5

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

JBeaucaire

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


ThisWorkbook.Save
Application.Qui
 
G

Gord Dibben

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
 
J

JBeaucaire

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?
 
G

Gord Dibben

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
 
Top