View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John Gregory[_2_] John Gregory[_2_] is offline
external usenet poster
 
Posts: 9
Default Sharing Workbooks With Macros

Well, Tom and Jim... I'm still waiting for something specific I can pass on
to you two from the two people who can't seem to open my workbook and make
the macros run. One guy tells me it's not the workbook nor the macros...
it's the operating system; XP. He says it prevents these workbooks from
executing the macros to protect itself. ???? Doesn't sound right to me,
but....

Is it?

"Tom Ogilvy" wrote in message
...
What error message do they get.

With only your workbook open,
They should go to the VBE and look in Tools=Reference and see if anything
is marked as MISSING.

If so, then if that item isn't used in your project, you should remove it

as
a reference from your copy of the workbook and save the workbook. Then

try
sending them the corrected version.

--
Regards,
Tom Ogilvy

"John Gregory" wrote in message
...
I'm new to using queries and recording macros but am into it up to my
eyeballs at present. MY project involves automating a workbook that

updates
economic indicators from various websites. The objective is to share the
results when finished with my investment club members.

When I sent the partially finished workbook to two members, neither were
able to run the macros. The queries could be executed but not the

macros.
Apparently something is stored on my computer that should have been

stored
with the workbook.

Can someone shed some light on this for me please?