LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default Assign keyboard short cut to subroutine

you can assign a keyboard short cut to a maco as you record it. Is it
possible to assign similar to a subroutine that you have contructed manually.
If not and it can only be done with macros, how do you write a macro manually
to include the subroutrine. In Access this is easy but it does not seem so
obvious in Excel.

Wher this is leading to is that I want to create a soubroutine and then save
the workbook as an Add-In. I then want other users to be able to access the
subroutine via the add-in using a keyboard short cut.

Thanks,
Andy.
 
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
Help for add a short cut keyboard to my add-in supercrs Excel Programming 1 June 5th 14 03:46 AM
find keyboard short-cut to type symbols on keyboard steamcomputerdriver Excel Discussion (Misc queries) 2 February 6th 10 01:58 PM
insert rows-keyboard short cut CLEM Excel Discussion (Misc queries) 7 June 6th 08 02:16 PM
keyboard short cut for highlighting a field Cindy Excel Worksheet Functions 5 January 18th 08 01:36 AM
can you customize a keyboard short cut in excel? Sue Excel Discussion (Misc queries) 3 June 2nd 05 10:49 PM


All times are GMT +1. The time now is 08:24 PM.

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

About Us

"It's about Microsoft Excel"