Hello,
I have linked a macro to Ctrl + Shift + O. I did this in several workbooks. If I press this key combination I only want to run the macro of the current active workbook. Now it seems that the macro of the wookbook that is first opened is called. How to solve this problem?
Edo
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi edo,
It's possible.
You need to use the Workbook_Activate event of the workbook to re-assign the shortcut key combination to the macro of that workbook.
The code looks like this
Private Sub Workbook_Activate()
Application.OnKey "+^o", "TestShortcuts"
End Sub
In my test example, I created a "TestShortcuts" module in each of the workbooks.
Good Luck
calacuccia
Hi edogroen,
Any update on this question?
in an effort to clean up old open questions
your options are:
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you, but may help others. You must tell the
participants why you wish to do this, and allow for Expert response. This choice will include a refund
to you, and will move this question to our PAQ (Previously Asked Question) database. If you found information
outside this question thread, please add it.
3. Ask Community Support to help split points between participating experts, or just comment here with
details and we'll respond with the process.
4. Delete the question (if it has no potential value for others).
--> Post comments for expert of your intention to delete and why
--> You cannot delete a question with comments, special handling by a Moderator is required.
For special handling needs, please post a zero point question in the link below, include the question
QID/link. http://www.experts-exchang
Please click this Help Desk link for Member Guidelines, Member Agreement and the Question/Answer process:
Click you Member Profile to view your question history and keep them all current with updates as the
collaboration effort continues. http://www.experts-exchang
------------> EXPERTS: Please leave any comments regarding this question here on closing recommendations
if this item remains inactive another seven (7) days.
--------------------------
Thanks
:O)Bruintje
--------------------------
Business Accounts
Answer for Membership
by: bruintjePosted on 2002-03-13 at 05:56:51ID: 6860571
Hi Edo, don't know if this is solvable except for opening the workbooks in seperate instances of XL. Or you should add a line in the macro that begins like
ActiveWorkbook.select
etc....rest of the code
HTH:O)Bruintje