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: 39
Default Conditional application.onkey in realtime?

Is there a way to use application.onkey to assign the same key to one
macro in workbookA and another Macro in workbookB? And have that same
shortcut key do nothing in WorkbookC? All three workbooks are open at
the same time so I want the appropriate macro to run in the active
workbook.

I tried a few ways making the application.onkey statement conditional
on the activeworkbook, but when the key was assigned, that was that.

TIA,

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
Application.onKey non-functioning Madhan Excel Programming 4 December 21st 06 04:39 PM
Application.OnKey Norman Jones Excel Programming 0 January 27th 05 01:26 AM
Application.OnKey problem R Avery Excel Programming 0 July 8th 04 06:38 PM
application.onkey doesn't work bob Excel Programming 2 May 10th 04 11:06 AM
Application.OnKey problem Phillip Reeves[_2_] Excel Programming 1 January 23rd 04 06:46 PM


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