Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default assign shortcut to macro

is it possible to programmatically assign a shortcut key to a macro? on close
for example?

--


Gary



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default assign shortcut to macro

Not sure what you mean by assign a key on close, but you can assign a button
in your toolbar to a macro, and you can assign some shortcut keys such as
when you record a macro
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Gary Keramidas" wrote:

is it possible to programmatically assign a shortcut key to a macro? on close
for example?

--


Gary




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 120
Default assign shortcut to macro

Have a look at this website, you`ll need to scroll down a bit

http://www.fontstuff.com/vba/vbatut07.htm

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default assign shortcut to macro

thanks, i'll give that a try.

--


Gary


"Keith74" wrote in message
oups.com...
Have a look at this website, you`ll need to scroll down a bit

http://www.fontstuff.com/vba/vbatut07.htm



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign shortcut keys droper Excel Discussion (Misc queries) 2 May 14th 07 09:59 AM
How do I assign keyboard shortcut for Grouping? Christina_0123 Excel Discussion (Misc queries) 0 May 3rd 06 05:27 PM
Assign Specific Function to Shortcut CA_Becker Excel Worksheet Functions 2 April 8th 05 05:53 PM
assign a symbol to a shortcut key Martin Hennegriff Excel Discussion (Misc queries) 1 March 10th 05 09:03 PM
not getting the "assign macro" shortcut JC Home[_2_] Excel Programming 3 October 2nd 04 11:07 PM


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"