LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Sending file using File/Send to/Mail Recipient Dawn Excel Discussion (Misc queries) 0 March 21st 10 09:24 PM
Hot Do I Send macros with Excel Workbooks? Portocar Excel Discussion (Misc queries) 4 September 27th 09 10:19 PM
How to save & send Excel files without macros. CC Excel Discussion (Misc queries) 6 October 13th 08 11:52 PM
unable to send excel file as attachment tab greyed out in file com Wayne Excel Discussion (Misc queries) 0 April 13th 06 10:06 PM
How do I send/email macros from my excel workbook to someone else? Drea Excel Worksheet Functions 1 August 10th 05 08:08 PM


All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"