Macro shortcut

[shakey]

I couldn't get a reply in excel programming group, hopefully here?
-
If I open a local file my shortcuts, to run macros, work fine but if I
download a file which opens in Excel my shortcuts will not work. However
selecting the drop down marco under tools does work from its RUN button and
displays the shortcut key as well as "all open workbooks" under edit.
What's stopping my shortcut from working?
Thanks
Mel

 

[David McRitchie]

If the file you download has the same name as your own file
you can only have one file open with the same name.

When you assign a shortcut it is stored in your Toolbars file and
will refer to the file at the location when you assigned the macro.
So it will include the full pathname.

If you want to use your macros in on several different files would
suggest you store your macros in your personal.xls workbook,
and hide that workbook

More information on personal.xls in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best to let Excel assign your personal.xls so it gets created in
the correct directory (XLSTART).

Additional pages that may be of interest include
http://www.mvps.org/dmcritchie/excel/shortx2k.htm builtin Shortcuts
http://www.mvps.org/dmcritchie/excel/toolbars.htm Toolbars
http://www.mvps.org/dmcritchie/excel/bqrhopper.htm Listing & fixing toolbars


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[shakey]

I looked thru the pages you suggested and did not find anything applicable
that was not already done, however I am not that sharpin Excel.
The strangest thging to me is that the macro will run if ran from the
toolbar macro pulldown menu but not from the shortcut.
I also recorded a new macro with new name and shortcut using the downloaded
file immediately after it downloaded and have same results IE marco works
but not from shortcut.
Please see my responces to your comments below.
Mel

If the file you download has the same name as your own file
you can only have one file open with the same name.

The downloaded file allways has a different name such as
pfmdownload.csv.xxxkeycodesxxx

When you assign a shortcut it is stored in your Toolbars file and
will refer to the file at the location when you assigned the macro.
So it will include the full pathname.

If you want to use your macros in on several different files would
suggest you store your macros in your personal.xls workbook,
and hide that workbook

The file I want to run is named personal.xls!sortstock and has ctrl+shift S
for its shortcut.
The personal.xls workbook is hidden.

More information on personal.xls in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best to let Excel assign your personal.xls so it gets created in
the correct directory (XLSTART).

Additional pages that may be of interest include
http://www.mvps.org/dmcritchie/excel/shortx2k.htm builtin Shortcuts
http://www.mvps.org/dmcritchie/excel/toolbars.htm Toolbars
http://www.mvps.org/dmcritchie/excel/bqrhopper.htm Listing & fixing
toolbars


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I couldn't get a reply in excel programming group, hopefully here?
-
If I open a local file my shortcuts, to run macros, work fine but if I
download a file which opens in Excel my shortcuts will not work. However
selecting the drop down marco under tools does work from its RUN button
and
displays the shortcut key as well as "all open workbooks" under edit.
What's stopping my shortcut from working?
Thanks
Mel

 

[Dave Peterson]

First, are you sure that your personal.xls workbook is opened?

Depending on how you built the pulldown menu, excel can open that personal.xls
file when you click on it.

(If you try the menu first (to load personal.xls), does the shortcut key work?)

Another way to check to see if personal.xls is open is to go to the VBE
(tools|macro|Visual Basic Editor), then hit ctrl-r to see the project explorer
and look for personal.xls in that "explorer" type list.

And if this didn't help, what happens if you try a shortcut key that doesn't
include the shiftkey?

I don't have much faith in that last suggestion if the shortcut key works ok
elsewhere.

===

And when you download the workbook, does it open in excel--or does it open in
MSIE?

I changed a setting (win98/xl2002/MSIE 6.x) to open a workbook within MSIE and a
shortcut to a macro in my personal.xla still worked--so I don't have much faith
in this suggestion, either.

But if you want to try, this may be useful:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

I looked thru the pages you suggested and did not find anything applicable
that was not already done, however I am not that sharpin Excel.
The strangest thging to me is that the macro will run if ran from the
toolbar macro pulldown menu but not from the shortcut.
I also recorded a new macro with new name and shortcut using the downloaded
file immediately after it downloaded and have same results IE marco works
but not from shortcut.
Please see my responces to your comments below.
Mel

If the file you download has the same name as your own file
you can only have one file open with the same name.

The downloaded file allways has a different name such as
pfmdownload.csv.xxxkeycodesxxx

When you assign a shortcut it is stored in your Toolbars file and
will refer to the file at the location when you assigned the macro.
So it will include the full pathname.

If you want to use your macros in on several different files would
suggest you store your macros in your personal.xls workbook,
and hide that workbook

The file I want to run is named personal.xls!sortstock and has ctrl+shift S
for its shortcut.
The personal.xls workbook is hidden.

More information on personal.xls in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best to let Excel assign your personal.xls so it gets created in
the correct directory (XLSTART).

Additional pages that may be of interest include
http://www.mvps.org/dmcritchie/excel/shortx2k.htm builtin Shortcuts
http://www.mvps.org/dmcritchie/excel/toolbars.htm Toolbars
http://www.mvps.org/dmcritchie/excel/bqrhopper.htm Listing & fixing
toolbars


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I couldn't get a reply in excel programming group, hopefully here?
-
If I open a local file my shortcuts, to run macros, work fine but if I
download a file which opens in Excel my shortcuts will not work. However
selecting the drop down marco under tools does work from its RUN button
and
displays the shortcut key as well as "all open workbooks" under edit.
What's stopping my shortcut from working?
Thanks
Mel

 

[David McRitchie]

Do you ever assign shortcut keys to macros outside of your personal.xls file.
Unfortunately there is no decent method of listing the shortcut keys.
I had the impression you were talking about toolbar buttons before.

I've given up on assigning and using my own shortcut keys because of
the lack of being able to document them independently of manually keeping
track of them. A solution I saw for documenting the shortcuts would take
several hours to run on my machine.

I don't think it has anything to do with your problem, but from your example
it looks like you are not displaying the file extensions.

First, are you sure that your personal.xls workbook is opened?

Depending on how you built the pulldown menu, excel can open that personal.xls
file when you click on it.

(If you try the menu first (to load personal.xls), does the shortcut key work?)

Another way to check to see if personal.xls is open is to go to the VBE
(tools|macro|Visual Basic Editor), then hit ctrl-r to see the project explorer
and look for personal.xls in that "explorer" type list.

And if this didn't help, what happens if you try a shortcut key that doesn't
include the shiftkey?

I don't have much faith in that last suggestion if the shortcut key works ok
elsewhere.

===

And when you download the workbook, does it open in excel--or does it open in
MSIE?

I changed a setting (win98/xl2002/MSIE 6.x) to open a workbook within MSIE and a
shortcut to a macro in my personal.xla still worked--so I don't have much faith
in this suggestion, either.

But if you want to try, this may be useful:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

I looked thru the pages you suggested and did not find anything applicable
that was not already done, however I am not that sharpin Excel.
The strangest thging to me is that the macro will run if ran from the
toolbar macro pulldown menu but not from the shortcut.
I also recorded a new macro with new name and shortcut using the downloaded
file immediately after it downloaded and have same results IE marco works
but not from shortcut.
Please see my responces to your comments below.
Mel

If the file you download has the same name as your own file
you can only have one file open with the same name.

The downloaded file allways has a different name such as
pfmdownload.csv.xxxkeycodesxxx

When you assign a shortcut it is stored in your Toolbars file and
will refer to the file at the location when you assigned the macro.
So it will include the full pathname.

If you want to use your macros in on several different files would
suggest you store your macros in your personal.xls workbook,
and hide that workbook

The file I want to run is named personal.xls!sortstock and has ctrl+shift S
for its shortcut.
The personal.xls workbook is hidden.

More information on personal.xls in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best to let Excel assign your personal.xls so it gets created in
the correct directory (XLSTART).

Additional pages that may be of interest include
http://www.mvps.org/dmcritchie/excel/shortx2k.htm builtin Shortcuts
http://www.mvps.org/dmcritchie/excel/toolbars.htm Toolbars
http://www.mvps.org/dmcritchie/excel/bqrhopper.htm Listing & fixing
toolbars


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I couldn't get a reply in excel programming group, hopefully here?
-
If I open a local file my shortcuts, to run macros, work fine but if I
download a file which opens in Excel my shortcuts will not work. However
selecting the drop down marco under tools does work from its RUN button
and
displays the shortcut key as well as "all open workbooks" under edit.
What's stopping my shortcut from working?
Thanks
Mel

 

[Dave Peterson]

I think you meant this for the OP, but just in case...

I only have a couple of shortcut keys in my personal.xla. Ctrl-q, ctrl-Q,
ctrl-t.

But as a personal choice, I either run macros from the menubar, the rightclick
menu, or a customized toolbar.

(And I do display the file extensions--I don't think that was meant for me
<bg>.)

Do you ever assign shortcut keys to macros outside of your personal.xls file.
Unfortunately there is no decent method of listing the shortcut keys.
I had the impression you were talking about toolbar buttons before.

I've given up on assigning and using my own shortcut keys because of
the lack of being able to document them independently of manually keeping
track of them. A solution I saw for documenting the shortcuts would take
several hours to run on my machine.

I don't think it has anything to do with your problem, but from your example
it looks like you are not displaying the file extensions.

First, are you sure that your personal.xls workbook is opened?

Depending on how you built the pulldown menu, excel can open that personal.xls
file when you click on it.

(If you try the menu first (to load personal.xls), does the shortcut key work?)

Another way to check to see if personal.xls is open is to go to the VBE
(tools|macro|Visual Basic Editor), then hit ctrl-r to see the project explorer
and look for personal.xls in that "explorer" type list.

And if this didn't help, what happens if you try a shortcut key that doesn't
include the shiftkey?

I don't have much faith in that last suggestion if the shortcut key works ok
elsewhere.

===

And when you download the workbook, does it open in excel--or does it open in
MSIE?

I changed a setting (win98/xl2002/MSIE 6.x) to open a workbook within MSIE and a
shortcut to a macro in my personal.xla still worked--so I don't have much faith
in this suggestion, either.

But if you want to try, this may be useful:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

I looked thru the pages you suggested and did not find anything applicable
that was not already done, however I am not that sharpin Excel.
The strangest thging to me is that the macro will run if ran from the
toolbar macro pulldown menu but not from the shortcut.
I also recorded a new macro with new name and shortcut using the downloaded
file immediately after it downloaded and have same results IE marco works
but not from shortcut.
Please see my responces to your comments below.
Mel
If the file you download has the same name as your own file
you can only have one file open with the same name.

The downloaded file allways has a different name such as
pfmdownload.csv.xxxkeycodesxxx


When you assign a shortcut it is stored in your Toolbars file and
will refer to the file at the location when you assigned the macro.
So it will include the full pathname.

If you want to use your macros in on several different files would
suggest you store your macros in your personal.xls workbook,
and hide that workbook

The file I want to run is named personal.xls!sortstock and has ctrl+shift S
for its shortcut.
The personal.xls workbook is hidden.


More information on personal.xls in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best to let Excel assign your personal.xls so it gets created in
the correct directory (XLSTART).

Additional pages that may be of interest include
http://www.mvps.org/dmcritchie/excel/shortx2k.htm builtin Shortcuts
http://www.mvps.org/dmcritchie/excel/toolbars.htm Toolbars
http://www.mvps.org/dmcritchie/excel/bqrhopper.htm Listing & fixing
toolbars


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I couldn't get a reply in excel programming group, hopefully here?
-
If I open a local file my shortcuts, to run macros, work fine but if I
download a file which opens in Excel my shortcuts will not work. However
selecting the drop down marco under tools does work from its RUN button
and
displays the shortcut key as well as "all open workbooks" under edit.
What's stopping my shortcut from working?
Thanks
Mel

 

[David McRitchie]

Of course, guess I should have said in addition to Dave's comments
that should confuse everybody including myself, except that I don't
call myself Dave. <grin>

The additional comment was also on the OP commentwhich does not show the file extension.

 

[shakey]

Apples and grapes?
Have I mislead you,if so sorry.
I am referring to the shortcut key which is assigned via the tools
dropdown"between format and data" which results in tools-macro-macros
then a list (1) Marco names personal.xls!sortstock
and it appears in all opened workbooks and also personal.xls
From here it runs via run button but simply using the shortcut assigned here
it don't.
I got worried if we were on same shortcut menu when you suggested using a
shortcut w/o shiftkey, that's not a option here.
Mel

First, are you sure that your personal.xls workbook is opened?

Depending on how you built the pulldown menu, excel can open that
personal.xls
file when you click on it.

(If you try the menu first (to load personal.xls), does the shortcut key
work?)

Another way to check to see if personal.xls is open is to go to the VBE
(tools|macro|Visual Basic Editor), then hit ctrl-r to see the project
explorer
and look for personal.xls in that "explorer" type list.

And if this didn't help, what happens if you try a shortcut key that
doesn't
include the shiftkey?

I don't have much faith in that last suggestion if the shortcut key works
ok
elsewhere.

===

And when you download the workbook, does it open in excel--or does it open
in
MSIE?

I changed a setting (win98/xl2002/MSIE 6.x) to open a workbook within MSIE
and a
shortcut to a macro in my personal.xla still worked--so I don't have much
faith
in this suggestion, either.

But if you want to try, this may be useful:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet
Explorer
http://support.microsoft.com/?scid=162059

I looked thru the pages you suggested and did not find anything
applicable
that was not already done, however I am not that sharpin Excel.
The strangest thging to me is that the macro will run if ran from the
toolbar macro pulldown menu but not from the shortcut.
I also recorded a new macro with new name and shortcut using the
downloaded
file immediately after it downloaded and have same results IE marco works
but not from shortcut.
Please see my responces to your comments below.
Mel

If the file you download has the same name as your own file
you can only have one file open with the same name.

The downloaded file allways has a different name such as
pfmdownload.csv.xxxkeycodesxxx

When you assign a shortcut it is stored in your Toolbars file and
will refer to the file at the location when you assigned the macro.
So it will include the full pathname.

If you want to use your macros in on several different files would
suggest you store your macros in your personal.xls workbook,
and hide that workbook

The file I want to run is named personal.xls!sortstock and has ctrl+shift
S
for its shortcut.
The personal.xls workbook is hidden.

More information on personal.xls in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best to let Excel assign your personal.xls so it gets created in
the correct directory (XLSTART).

Additional pages that may be of interest include
http://www.mvps.org/dmcritchie/excel/shortx2k.htm builtin Shortcuts
http://www.mvps.org/dmcritchie/excel/toolbars.htm Toolbars
http://www.mvps.org/dmcritchie/excel/bqrhopper.htm Listing & fixing
toolbars


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I couldn't get a reply in excel programming group, hopefully here?
-
If I open a local file my shortcuts, to run macros, work fine but if I
download a file which opens in Excel my shortcuts will not work.
However
selecting the drop down marco under tools does work from its RUN
button
and
displays the shortcut key as well as "all open workbooks" under edit.
What's stopping my shortcut from working?
Thanks
Mel

 

[Dave Peterson]

Nope, same fruit!

When your in that dialog (tools|macro|macros|options button, if you hit the
shift key, the dialog displays:
Ctrl+Shift+(somecharacter)

If you assign the shortcut key (without hitting the shift key (use lower case a
instead of upper case A), what happens?

(I still have no expectation that this is the problem, though.)

Apples and grapes?
Have I mislead you,if so sorry.
I am referring to the shortcut key which is assigned via the tools
dropdown"between format and data" which results in tools-macro-macros
then a list (1) Marco names personal.xls!sortstock
and it appears in all opened workbooks and also personal.xls
From here it runs via run button but simply using the shortcut assigned here
it don't.
I got worried if we were on same shortcut menu when you suggested using a
shortcut w/o shiftkey, that's not a option here.
Mel

First, are you sure that your personal.xls workbook is opened?

Depending on how you built the pulldown menu, excel can open that
personal.xls
file when you click on it.

(If you try the menu first (to load personal.xls), does the shortcut key
work?)

Another way to check to see if personal.xls is open is to go to the VBE
(tools|macro|Visual Basic Editor), then hit ctrl-r to see the project
explorer
and look for personal.xls in that "explorer" type list.

And if this didn't help, what happens if you try a shortcut key that
doesn't
include the shiftkey?

I don't have much faith in that last suggestion if the shortcut key works
ok
elsewhere.

===

And when you download the workbook, does it open in excel--or does it open
in
MSIE?

I changed a setting (win98/xl2002/MSIE 6.x) to open a workbook within MSIE
and a
shortcut to a macro in my personal.xla still worked--so I don't have much
faith
in this suggestion, either.

But if you want to try, this may be useful:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet
Explorer
http://support.microsoft.com/?scid=162059

I looked thru the pages you suggested and did not find anything
applicable
that was not already done, however I am not that sharpin Excel.
The strangest thging to me is that the macro will run if ran from the
toolbar macro pulldown menu but not from the shortcut.
I also recorded a new macro with new name and shortcut using the
downloaded
file immediately after it downloaded and have same results IE marco works
but not from shortcut.
Please see my responces to your comments below.
Mel
If the file you download has the same name as your own file
you can only have one file open with the same name.

The downloaded file allways has a different name such as
pfmdownload.csv.xxxkeycodesxxx


When you assign a shortcut it is stored in your Toolbars file and
will refer to the file at the location when you assigned the macro.
So it will include the full pathname.

If you want to use your macros in on several different files would
suggest you store your macros in your personal.xls workbook,
and hide that workbook

The file I want to run is named personal.xls!sortstock and has ctrl+shift
S
for its shortcut.
The personal.xls workbook is hidden.


More information on personal.xls in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best to let Excel assign your personal.xls so it gets created in
the correct directory (XLSTART).

Additional pages that may be of interest include
http://www.mvps.org/dmcritchie/excel/shortx2k.htm builtin Shortcuts
http://www.mvps.org/dmcritchie/excel/toolbars.htm Toolbars
http://www.mvps.org/dmcritchie/excel/bqrhopper.htm Listing & fixing
toolbars


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I couldn't get a reply in excel programming group, hopefully here?
-
If I open a local file my shortcuts, to run macros, work fine but if I
download a file which opens in Excel my shortcuts will not work.
However
selecting the drop down marco under tools does work from its RUN
button
and
displays the shortcut key as well as "all open workbooks" under edit.
What's stopping my shortcut from working?
Thanks
Mel

 

[David McRitchie]

That answers if there was a pathname with that macro, because
when things get moved around you end up with a different path
and a file not found. That is not the case and it indicates your
personal.xls One more thing to check probably won't show anything.

Possibility of two macros with the same name, checking the module
itself for duplicate is simple. Checking the rest of the macros
You can use List Formulas and Subs. I'm not sure what kind of
an error you get so you might want to check this out.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
On second thought just check to same module, if there were
two macros with same name in different modules you would see
both in Macro list (Alt+F8).

That is a very remote possibility and I'm not really sure what kind of
errors that would cause, didn't try to check what
it would look like. After that I can't think of anything.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Apples and grapes?
Have I mislead you,if so sorry.
I am referring to the shortcut key which is assigned via the tools
dropdown"between format and data" which results in tools-macro-macros
then a list (1) Marco names personal.xls!sortstock
and it appears in all opened workbooks and also personal.xls
From here it runs via run button but simply using the shortcut assigned here
it don't.
I got worried if we were on same shortcut menu when you suggested using a
shortcut w/o shiftkey, that's not a option here.
Mel

First, are you sure that your personal.xls workbook is opened?

Depending on how you built the pulldown menu, excel can open that
personal.xls
file when you click on it.

(If you try the menu first (to load personal.xls), does the shortcut key
work?)

Another way to check to see if personal.xls is open is to go to the VBE
(tools|macro|Visual Basic Editor), then hit ctrl-r to see the project
explorer
and look for personal.xls in that "explorer" type list.

And if this didn't help, what happens if you try a shortcut key that
doesn't
include the shiftkey?

I don't have much faith in that last suggestion if the shortcut key works
ok
elsewhere.

===

And when you download the workbook, does it open in excel--or does it open
in
MSIE?

I changed a setting (win98/xl2002/MSIE 6.x) to open a workbook within MSIE
and a
shortcut to a macro in my personal.xla still worked--so I don't have much
faith
in this suggestion, either.

But if you want to try, this may be useful:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet
Explorer
http://support.microsoft.com/?scid=162059

I looked thru the pages you suggested and did not find anything
applicable
that was not already done, however I am not that sharpin Excel.
The strangest thging to me is that the macro will run if ran from the
toolbar macro pulldown menu but not from the shortcut.
I also recorded a new macro with new name and shortcut using the
downloaded
file immediately after it downloaded and have same results IE marco works
but not from shortcut.
Please see my responces to your comments below.
Mel
If the file you download has the same name as your own file
you can only have one file open with the same name.

The downloaded file allways has a different name such as
pfmdownload.csv.xxxkeycodesxxx


When you assign a shortcut it is stored in your Toolbars file and
will refer to the file at the location when you assigned the macro.
So it will include the full pathname.

If you want to use your macros in on several different files would
suggest you store your macros in your personal.xls workbook,
and hide that workbook

The file I want to run is named personal.xls!sortstock and has ctrl+shift
S
for its shortcut.
The personal.xls workbook is hidden.


More information on personal.xls in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best to let Excel assign your personal.xls so it gets created in
the correct directory (XLSTART).

Additional pages that may be of interest include
http://www.mvps.org/dmcritchie/excel/shortx2k.htm builtin Shortcuts
http://www.mvps.org/dmcritchie/excel/toolbars.htm Toolbars
http://www.mvps.org/dmcritchie/excel/bqrhopper.htm Listing & fixing
toolbars


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I couldn't get a reply in excel programming group, hopefully here?
-
If I open a local file my shortcuts, to run macros, work fine but if I
download a file which opens in Excel my shortcuts will not work.
However
selecting the drop down marco under tools does work from its RUN
button
and
displays the shortcut key as well as "all open workbooks" under edit.
What's stopping my shortcut from working?
Thanks
Mel