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.

Try attaching the Toolbar through ToolsCustomizeAttach.

Alternative.........create the Toolbar when the file is opened.

This would involve some VBA coding in Workbook-open

For examples see.....

http://support.microsoft.com/default...EN-US;Q166755&

Gord Dibben Excel MVP

On Thu, 22 Jul 2004 13:43:07 -0400, "Tom Ogilvy" wrote:

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.