Macros are contained in a workbook. If you email the workbook, then the
macros originally in that workbook should be present. This assumes they are
using xl97 or later.

--
Regards,
Tom Ogilvy

"Aimee" wrote in message
...
Hi all,

I am new to using macros, so forgive me if this question
is elementary.

I've created a program/file using Excel 2000 that allows
the user to paste objects onto a page by choosing the
object from a toolbar. This enables the user to customize
the pages. The objects on the toolbar have macros
connected to them allowing for the objects to be copied
from a hidden worksheet and then pasted onto the selected
page.

Sheets("Word Datasheets").Visible = True
Sheets("Word Datasheets").Select
ActiveSheet.Shapes("objBrightness").Select
Selection.Copy
Sheets("Word Datasheets").Visible = False
Sheets("Datasheets").Select
ActiveSheet.Paste

My problem is that users with other computers are not able
to use the toolbar macros. I have tried emailing the file
and also tried copying it onto a disk, but the macros are
not present when the other users open the file.

Is there a way to copy the macros with the file, or
another way to make the macros appear? Any help would be
greatly appreciated.