Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Sending file using File/Send to/Mail Recipient | Excel Discussion (Misc queries) | |||
Hot Do I Send macros with Excel Workbooks? | Excel Discussion (Misc queries) | |||
How to save & send Excel files without macros. | Excel Discussion (Misc queries) | |||
unable to send excel file as attachment tab greyed out in file com | Excel Discussion (Misc queries) | |||
How do I send/email macros from my excel workbook to someone else? | Excel Worksheet Functions |