Need help creating shortcut keys to add-in macros

btadams

Well-known Member

Joined

Jan 6, 2003

Messages

1,943

• Mar 26, 2003

• #2

take a look here....

http://www.j-walk.com/ss/excel/faqs/xl97faq4.htm

apparently you only need to execute the code once and the information gets stored with the workbook. You then need to remove the Application.MacroOption lines from your add-in or else you'll get an error message when you launch Excel.

 

Upvote 0

M

mbrittb

Board Regular

Joined

Jul 24, 2002

Messages

62

• Mar 26, 2003

• #3

I checked out the link from your response. Unfortunatlly it did not answer my problem. I am trying to create a shortcut key definition (similar to ctrl-s for saving) to activate a particular macro in my addin. Maybe I missed it, but that linkdidn't have anything along those lines.

 

Upvote 0

btadams

Well-known Member

Joined

Jan 6, 2003

Messages

1,943

• Mar 26, 2003

• #4

Sorry about that. I meant this:

http://www.j-walk.com/ss/excel/tips/tip27.htm

 

Upvote 0

M

mbrittb

Board Regular

Joined

Jul 24, 2002

Messages

62

• Mar 26, 2003

• #5

Ok,
1) where do I need to put those functions? ThisWorkbook?

2) do you have a list of how to define the keys, or combinations of them. i.e. page down is specified by the code PgDn. What would say Control-s, or Control-w be.

Thanks,

Britt

 

Upvote 0

btadams

Well-known Member

Joined

Jan 6, 2003

Messages

1,943

• Mar 26, 2003

• #6

I would put then in the Workbook_Open event (or in a macro that is called via the Workbook_Open event

The code would look like this:

Application.OnKey "^s" "MyMacroName"


you may also want toreturn the Ctrl+S shortcut to it's default in the Workbook_Close event with a line like this:

Application.OnKey "^s"

 

Upvote 0

M

mbrittb

Board Regular

Joined

Jul 24, 2002

Messages

62

• Mar 26, 2003

• #7

Great. Thanks for the help.

 

Upvote 0

M

mbrittb

Board Regular

Joined

Jul 24, 2002

Messages

62

• Mar 26, 2003

• #8

Great. Thanks for the help.

 

Upvote 0