Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ted Ted is offline
external usenet poster
 
Posts: 48
Default Macro Portability Problem

I have a worksheet with several macros in it. The macros work properly when
I run them on my computer, but they can't be found when I try the worksheet
on any other computer. how do I ensure the macros will stay with the
worksheet if I move it?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 523
Default Macro Portability Problem

They will move with the workbook.

Check the macro security settings on the other computers - in excel 2003 go
to Tools/Macros/Security and set it to Medium, then re-open the workbook and
enable macros. In 2007 you need to go into the trust centre.

Sam


"Ted" wrote:

I have a worksheet with several macros in it. The macros work properly when
I run them on my computer, but they can't be found when I try the worksheet
on any other computer. how do I ensure the macros will stay with the
worksheet if I move it?

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
Custom toolbars and Excel 2003 - 2007 portability lwert Excel Programming 1 May 13th 08 09:05 PM
PORTABILITY ISSUES with Excel Addin in VBA Sandeep Excel Discussion (Misc queries) 3 July 10th 07 05:06 PM
macros, selfcert, portability George Excel Discussion (Misc queries) 0 October 31st 05 05:10 AM
Portability of program in Excel 2000 ricedo Excel Programming 0 May 23rd 04 11:44 AM
Portability of early bound code - clarification Pete McCosh[_5_] Excel Programming 4 November 25th 03 03:53 PM


All times are GMT +1. The time now is 07:39 PM.

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

About Us

"It's about Microsoft Excel"