send macros with file
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.
|