Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Hot Do I Send macros with Excel Workbooks?

When I send via email a workbook for which I have written macros the macros
do not work for the recipient.
Is there any way to be sure that the macros are emailed as part of the
workbook?
Thanks,
portocar
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Hot Do I Send macros with Excel Workbooks?

What version of excel are you using?
What version of excel is the recipient using?
What is the file format of the workbook you're sharing?

Is the recipient allowing macros to run when he/she opens the file?

Is there an antivirus program (at either end) that could be interfering?

Portocar wrote:

When I send via email a workbook for which I have written macros the macros
do not work for the recipient.
Is there any way to be sure that the macros are emailed as part of the
workbook?
Thanks,
portocar


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,071
Default Hot Do I Send macros with Excel Workbooks?

The macros are a part of the workbook. When you send the workbook, you send
the macros. Read what Dave said. HTH Otto
"Portocar" wrote in message
...
When I send via email a workbook for which I have written macros the
macros
do not work for the recipient.
Is there any way to be sure that the macros are emailed as part of the
workbook?
Thanks,
portocar



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Hot Do I Send macros with Excel Workbooks?

That is true so long as the macros, if recorded, were recorded in 'This
Workbook' and not into a different workbook or are in his Personal.xls file.

But I, just like you, suspect that something that Dave Peterson addressed is
the real culprit.

"Otto Moehrbach" wrote:

The macros are a part of the workbook. When you send the workbook, you send
the macros. Read what Dave said. HTH Otto
"Portocar" wrote in message
...
When I send via email a workbook for which I have written macros the
macros
do not work for the recipient.
Is there any way to be sure that the macros are emailed as part of the
workbook?
Thanks,
portocar




  #5   Report Post  
Posted to microsoft.public.excel.misc
Geo Geo is offline
external usenet poster
 
Posts: 66
Default Hot Do I Send macros with Excel Workbooks?

Lower the security settings in the recipients side.

hoyos

"JLatham" wrote:

That is true so long as the macros, if recorded, were recorded in 'This
Workbook' and not into a different workbook or are in his Personal.xls file.

But I, just like you, suspect that something that Dave Peterson addressed is
the real culprit.

"Otto Moehrbach" wrote:

The macros are a part of the workbook. When you send the workbook, you send
the macros. Read what Dave said. HTH Otto
"Portocar" wrote in message
...
When I send via email a workbook for which I have written macros the
macros
do not work for the recipient.
Is there any way to be sure that the macros are emailed as part of the
workbook?
Thanks,
portocar






Reply
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
Macros common to several workbooks Jayen Excel Worksheet Functions 2 October 31st 08 02:22 PM
How to save & send Excel files without macros. CC Excel Discussion (Misc queries) 6 October 13th 08 11:52 PM
Excel 2003 Workbooks with macros (.xls) converted to Excel 2007 Barb Reinhardt Excel Discussion (Misc queries) 6 September 1st 07 06:58 AM
My send to in excel/word does not offer send as attachment Mstink Excel Discussion (Misc queries) 11 March 16th 06 02:49 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 05:45 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"