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: 14
Default Run a macro shortcut from another macro?

I use Ctrl+n to run a macro

I now need to run this macro from another macro.
Tried using SendKeys "^%n", Wait:=True
but this didn't work. I cannot directly reference the
macro as there may be another workbook open (as
thisworkbook) that contains the same macro name but works
slightly differently - but if CTRL+n is pressed i have set
it up so that the macro from the activeworkbook will run.

can anyone help?
thanks
George
 
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
macro shortcut help ericaamousseau Excel Worksheet Functions 1 March 23rd 10 07:01 PM
Shortcut to a Macro Susan Excel Discussion (Misc queries) 2 July 11th 08 05:18 PM
Macro Shortcut Alex[_13_] Excel Programming 3 June 1st 04 12:55 PM
Macro shortcut key Gandei Excel Programming 2 December 5th 03 04:40 PM
Macro shortcut from XLA Conceptor[_2_] Excel Programming 1 November 11th 03 11:54 PM


All times are GMT +1. The time now is 02:02 AM.

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"