View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Sharing Workbooks With Macros

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?