Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default How to assign a macro to a key e.g. ctrl-S

I have a macro that does a "paste-special, transpose" and I would like to
assign this action to a keypress. How is that done?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default How to assign a macro to a key e.g. ctrl-S

In the worksheet, pull-down:

Tools Macro Macros Options

then enter a short-cut-key


--
Gary''s Student


"MikeT" wrote:

I have a macro that does a "paste-special, transpose" and I would like to
assign this action to a keypress. How is that done?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default How to assign a macro to a key e.g. ctrl-S

Thanks.....

"Gary''s Student" wrote:

In the worksheet, pull-down:

Tools Macro Macros Options

then enter a short-cut-key


--
Gary''s Student


"MikeT" wrote:

I have a macro that does a "paste-special, transpose" and I would like to
assign this action to a keypress. How is that done?

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
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets DrDave Excel Discussion (Misc queries) 1 July 28th 08 04:12 AM
how do I assign a CTRL + shortcut key to a menu item (paste speci. PaulGB Excel Discussion (Misc queries) 1 July 14th 08 03:19 AM
use CTRL key inside a macro IE CTRL + ; Date Less Excel Worksheet Functions 1 April 14th 08 11:58 PM
Esc Key Macro instead of Ctrl+... Dajana Excel Discussion (Misc queries) 2 November 29th 05 11:19 PM
How to assign Ctrl+Shift+Insert to Paste Values? [email protected] Excel Discussion (Misc queries) 5 October 3rd 05 10:43 PM


All times are GMT +1. The time now is 07:18 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"