Workbook Sometimes Doesn't Find Macro in Another Workbook

klem_is_me

New Member
Joined
Feb 1, 2016
Messages
1
I have a workbook that has a macro in it that other workbooks access. I find that sometimes when I open another workbook which doesn't contain the macro and try to run that other workbook's macro, sometimes it finds it and sometimes it doesn't.

Details: The main WB that has the macro is open and has a hotkey associated to it (CTL-k). I receive many workbooks (w/o macros) as attachments to Outlook messages. I copy the attached WB to the desktop and then open it as Excel. I find that if the WB opens quickly (they are small and all about the same size), I can hit the hotkey and the macro runs. If it opens slowly and I hit the hotkey, the macro doesn't run and in fact opens the default action for CTL-k (hyperlink) and if I click macro on the ribbon, there is no macros listed.

I can close that WB I opened from the desktop and reopen it and it will open quickly and run.

Any ideas on what I'm missing? Thanks.
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top