Hi Dave

I'm not sure, if that will do the trick. I have a lot of workbooks, that I
send to other users. In each is a single macro. They do not do excactly the
same, but do something related to the workbook they are in. Right now all
the macros are assigned to Ctrl+d. When a user opens a wokbook a text in one
of the cells tell the user "Fill in the form and Press Ctrl+d" to execute".
Så thats what the user does. Problem is, when the users opens more than one
workbook at a time, the Ctrl+d does not do the right thing, if a "wrong"
workbook is active. And that it is not so good, if the macro deletes a
worksheet that should not have been deleted, just because the wrong workbook
is open.

I can of course use diffenrent shortcuts, but one time or another, I run out
of keys. And for an untrained user, I think it would be to difficult to
remember, which shortcut goes with which workbook.

But anyway, you have almost convinced me, that it cannot be done, so I have
to think of another way.

Jan

Dave Peterson wrote:
ps.

You may want to run the macros another way:

For additions to the worksheet menu bar, I really like the way John
Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under
the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron
de Bruin's site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks
(saved as an addin)
or
http://www.rondebruin.nl/2007addin.htm

Dave Peterson wrote:

I don't think so.

Maybe you can use D and d as the letters in your shortcuts????

Jan Kronsell wrote:

In each of two workbooks I have a macro. Both are assigned to
ctrl+d.
When only one of the workbooks are opened it works ok. When both
workvooks are opened, prbolems occur.

No matter which workbook I open first, its always the macro in the
workbook, where I first assigned the shortcut, that is run.

Is thetre any way, that I can ensure, that the macro in the active
workbook is run, when more macros are assigned til the same
shortcut key?

Jan

--

Dave Peterson